Oracle如何选择具有自定义名称的列(Oracle how to select column with custom name)

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 value

i 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