Re: Weird SQL

From: Maxim Demenko <mdemenko_at_arcor.de>
Date: Thu, 18 May 2006 11:06:48 +0200
Message-ID: <446c3a61$0$4495$9b4e6d93@newsread2.arcor-online.net>

Michel Cadot schrieb:

> SQL> select * from (select 1 a from dual) where a in (select a from dual);
>
> A
> ----------
> 1
>
> 1 row selected.
>

> All expressions/columns of a query are visible to its first level subquery.
>
> Regards
> Michel Cadot
>
>

And all further nested subqueries up to 255 nested levels.

scott_at_ORA102> select *

   2 from (select 1 a from dual)
   3 where a in (select a

   4              from dual
   5              where exists (select a
   6                            from dual
   7                            where a in ( select a from dual))) -- 

may be continued

   8 /

          A

---

          1

Best regards

Maxim Received on Thu May 18 2006 - 04:06:48 CDT