Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Quotes in a column alias

Billy VerreynneMay 17 2011 — edited May 17 2011
Possible to have double quotes in a column alias in a SQL projection? Long story involving Apex, Anychart v5 and how Apex names data serie in XML generated for multiple Y axis.

This problem can be easily solved if I can add a double quote into a column alias. E.g.
select
  some_col as "COL1"" param1=123"
from dual
No comment about Apex using column labels for generating XML tag name-values... {noformat} ;-) {noformat}

Of course, the SQL parser does not like the above format at all.

Had a look at the SQL Reference guide and it does not say much in this regard. Seems like there's no workaround - correct?
This post has been answered by MichaelS on May 17 2011
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jun 14 2011
Added on May 17 2011
5 comments
671 views