且构网

分享程序员开发的那些事...
且构网 - 分享程序员编程开发的那些事

如何在 Oracle SQL 开发人员中以驼峰形式获取列名

更新时间:2023-01-22 18:50:14

如果列别名用双引号括起来,SQL Developer 将使用这些精确值作为查询结果中的列名:

If the column aliases are wrapped in double-quotes, SQL Developer will use those exact values as the column names in the query results:

SELECT name AS "CandidateName", age AS "CandidateAge"
FROM tbl_candidate_details
ORDER BY candidate_id DESC;

否则查询结果中的列名总是大写

Otherwise, the column names in the query results are always displayed in upper case