Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Nested Selects
This feature officially was introduced in Oracle 7.3. Unofficially, who
knows. BTW, it's called inline views.
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 - 00:58:44 CST