WITH CLAUSE IMPROVEMENTS

WITH CLAUSE IMPROVEMENTS

In 12c, you can have faster running PL/SQL function/procedure in SQL, that are defined and declared within theWITH clause of SQL statements. The following examples demonstrate how to define and declare a procedure or function within the WITH clause:

WITH

PROCEDURE|FUNCTION test1 (…)

BEGIN

    <logic>

  END;

ion|procedure_here> FROM table_name;

/

SELECT <referece_your_funct

Although you can’t use the WITH clause directly in the PL/SQL unit, it can be referred through a dynamic SQL within that PL/SQL unit.