WITH CLAUSE IMPROVEMENTS

ONLINE RENAME AND RELOCATION OF AN ACTIVE DATA FILE, AskHareesh.blogspot.com
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.
*/