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!

Calculate column alias

465486Sep 10 2007 — edited Sep 11 2007
Hello Tom,
Hello Gurus

How can I in a query reference a calculated column somehow in the select list?

select
dummy||dummy as double_dummy
double_dummy||dummy as triple_dummy
from dual

That would be the pseudo code, but I don't know how to implement it. My real calculations are
already 200 chars long and then I have to use it in other calculations...
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Oct 9 2007
Added on Sep 10 2007
21 comments
1,326 views