Skip to Main Content
Forums

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!

Name of column in select

zd417836kaMar 26 2004 — edited Jan 23 2006
Hi, I need to give a name column and work with this name in other column's. It's possible?
i.e.
select (case when shkzg = 'S' then 'MD' else 'D' end) as name, name, name||name, ....
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Feb 20 2006
Added on Mar 26 2004
5 comments
316 views