Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Nested Selects
A copy of this was sent to adizon_at_us.net (Lito Dizon)
(if that email address didn't require changing)
On Thu, 05 Nov 1998 22:27:41 GMT, you 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.
It was first introduced in 7.1 of Oracle. It was documented with 7.2. Pl/sql supported this construct starting with 7.3 (prior to that you had to use dbms_sql to let pl/sql use inline views as they are known).
Thomas Kyte
tkyte_at_us.oracle.com
Oracle Government
Herndon VA
--
http://govt.us.oracle.com/ -- downloadable utilities
Anti-Anti Spam Msg: if you want an answer emailed to you, you have to make it easy to get email to you. Any bounced email will be treated the same way i treat SPAM-- I delete it. Received on Sat Nov 07 1998 - 08:06:23 CST