Pavlo C. February 2016

Can I name SQL's result columns with camel-case aliases?

How can I name SQL's result columns with camel-case aliases?
I am interested to use it for MySQL and Oracle 10g/11g.

Answers


Pavlo C. February 2016

As Shannon Severance suggested:

At least in Oracle, you can Quote the aliases. select some_column as "SomeColumn"

and as for MySQL - it simply uses provided column names without pre-capitalizing them. The same is true for aliases. Result of
SELECT customerName ... from ...
will have column with exactly the same name in camel-case.

Post Status

Asked in February 2016
Viewed 3,156 times
Voted 10
Answered 1 times

Search




Leave an answer