Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: select in FROM clauses
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