Oracle如何选择具有自定义名称的列(Oracle how to select column with custom name)
我正在复杂的选择查询工作,我想选择具有某种特定格式的列名,但oracle只给我大写字母。
select no_constat as noFolder from cef_constat;oracle给了我:
**nofolder** value value value我希望列名像这样noFolder
我想要大写字母'F'
你知道如何实现这个目标吗?
i'm working in complex select query and i want to select column names with some specific format, but oracle give me only capital letter.
select no_constat as noFolder from cef_constat;oracle gives me :
**nofolder** value value valuei want the column name like this noFolder
i want the 'F' in capital letter
do you have any idea how to achieve this ?
最满意答案
尝试这个:
select nofolder as "noFolder" from your_table;这是有效的,因为引用的标识符不会折叠为大写。
手册中提供了详细信息
Try this:
select nofolder as "noFolder" from your_table;This works, because quoted identifier are not folded to uppercase.
Details are available in the manual
更多推荐
发布评论