Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Nested Selects

Nested Selects

From: Lito Dizon <adizon_at_us.net>
Date: Thu, 05 Nov 1998 22:27:41 GMT
Message-ID: <36422501.88402026@news.us.net>


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 Thu Nov 05 1998 - 16:27:41 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US