Re: Nested Selects

Starting with 7.2.2 or 7.2.3 I believe. It is also called 'inline -views'

Sybrand Bakker, Oracle DBA

Lito Dizon wrote:

> I just discovered today that I can do nested selects like below in
> Oracle 7.3. Has this feature been around?
>
> select * from
> (select * from
> ( select * from mytable ))
>
> In fact I was able to go up to 26 levels.
Received on Sat Nov 07 1998 - 08:03:42 CST