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

Home -> Community -> Usenet -> c.d.o.misc -> Re: select in FROM clauses

Re: select in FROM clauses

From: Chris Halioris <halioris_chris_nonlilly_at_lilly.com>
Date: 1997/03/03
Message-ID: <331B0D89.2498@lilly.com>#1/1

Arturo García wrote:
>
> Does Oracle support 'SELECT' sentences in FROM clauses?
> Example:
>
> SELECT ... FROM (SELECT ... FROM TABLE1)
>
> Arturo García
> arturog_at_jet.es

Yes. I believe it was intorduced in 7.2. Maybe earlier I'm not sure but I use it in 7.2 and 7.3 and it works great.

Chris Halioris
Tactics, Inc.
hali_at_tacticsus.com Received on Mon Mar 03 1997 - 00:00:00 CST

Original text of this message

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