RE: Selecting for Dummies
- From: TJ Kiernan <tkiernan@xxxxxxxxxxx>
- To: "'nmjamaleddin@xxxxxxxxxxxxxxxx'" <nmjamaleddin@xxxxxxxxxxxxxxxx>, "oracle-l@xxxxxxxxxxxxx" <oracle-l@xxxxxxxxxxxxx>
- Date: Tue, 19 Nov 2013 15:04:28 +0000
Yes, this is normal. From
http://asktom.oracle.com/pls/asktom/f?p=100:11:0::::P11_QUESTION_ID:1853075500346799932,
"ANSI SQL has table references (correlation names) scoped to just one level
deep"
HTH,
T. J.
From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On
Behalf Of Nabil Jamaleddin
Sent: Tuesday, November 19, 2013 8:54 AM
To: oracle-l@xxxxxxxxxxxxx
Subject: Selecting for Dummies
This works fine:
select (select b.dummy from dual b where b.dummy = a.dummy) from dual a;
But this does not...
select (select * from (select b.dummy from dual b where b.dummy = a.dummy))
from dual a;
ora-00904 a.dummy: invalid identifier
a.dummy seems to lose focus after getting nested twice. Is this normal?
Using oracle 11.2.0.3 on Linux.
------------------------------------------------------------------
This email is intended solely for the use of the addressee and may
contain information that is confidential, proprietary, or both.
If you receive this email in error please immediately notify the
sender and delete the email.
------------------------------------------------------------------
Other related posts:
