Re: SQL question

From: Michel Cadot <micadot{at}altern{dot}org>
Date: Thu, 20 Oct 2005 18:47:45 +0200
Message-ID: <4357ca2f$0$19235$626a54ce@news.free.fr>

"Maxim Demenko" <mdemenko_at_gmail.com> a écrit dans le message de news: dj6d9s$qb0$02$1_at_news.t-online.com...
|
| I can't answer your question, but , apparently, my post was not correct
| in general case - the restriction on only 1 level visibility scope
| doesn't apply for usual correlated subqueries - this seems to work:
|
| SQL> SELECT dummy
| 2 FROM dual a
| 3 WHERE EXISTS
| 4 (SELECT 1
| 5 FROM dual b
| 6 WHERE a.dummy = b.dummy
| 7 AND EXISTS
| 8 (SELECT 1
| 9 FROM dual c
| 10 WHERE c.dummy = a.dummy)
| 11 )
| 12 /
|
| DUM
| ---
| X
|
| SQL>
|
| Best regards
|
| Maxim
|

Interesting, indeed!

Regards
Michel Cadot Received on Thu Oct 20 2005 - 11:47:45 CDT