Search SSWUG.ORG:

DATABASES

SQL: combine inline PL/SQL function with inline view in Oracle Database 12c SQL Query This is an off-site link.  Please review our Terms of Service for additional information.




(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. Oracle Database release 12c (12.1) added a new feature into this mix: Inline PL/SQL functions, using a syntax like: with function x (p_in varchar2) return varchar2 is begin return ‘X’;end; select x(‘ahaha’) from dual.

Read this article...







comments powered by Disqus