Tag: inline function

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

Lucas Jellema June 25, 2014 Database, SQL No Comments

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 …

[Continue Reading...]

Oracle Database 12c: In Line PL/SQL Functions in SQL queries

Lucas Jellema June 25, 2013 Oracle, Oracle 12, PL/SQL 5 Comments

At long last it’s here: Oracle Database 12cR1. The download of this fresh software package is hardly done. It is time to start sharing some of our early experiences …

[Continue Reading...]