SQL: combine inline PL/SQL function with inline view in Oracle Database 12c SQL Query

(Lucas Jellema) Oracle Database 7.3 was the first to support inline views – using the select * from (select * from) syntax. Oracle Database 9i added the with clause for subquery factoring, using a syntax like with vw as (select * from) , vw2 as (select * from vw) select * from vw2 join vw join tbl.

Read More - Register for Free Membership