Skip to Main Content

Oracle Database Discussions

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!

Use of a alias in one subquery

458726Feb 1 2006 — edited Feb 2 2006
Executing the command below it returns an error informing that "A1" is an invalid identification.

select 1 as a1, (select a1 as b2 from dual) as b1 from dual

Is not possible to create one alias and to use it in one subquery in the same command?
It exists another form of if getting this result?
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Mar 2 2006
Added on Feb 1 2006
14 comments
528 views