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: Thomas J. Kyte <tkyte_at_us.oracle.com>
Date: 1997/03/01
Message-ID: <331793be.2571637@nntp.mediasoft.net>#1/1

it was silently introduced in 7.1

documented as a feature in 7.2

supported in pl/sql with 7.3 (prior to that, you had to hide it in a view or use dbms_sql to dynamically process query with that syntax in pl/sql)

On Fri, 28 Feb 1997 17:08:18 +0100, Arturo García <arturog_at_jet.es> wrote:

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

Thomas Kyte
Oracle Government
tkyte_at_us.oracle.com                          

http://govt.us.oracle.com


statements and opinions are mine and do not necessarily reflect the opinions of Oracle Corporation Received on Sat Mar 01 1997 - 00:00:00 CST

Original text of this message

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