dbms_preprocessor.print_post_processed_source : dbms_preprocessor « System Packages « Oracle PL/SQL Tutorial

1. Oracle PL/SQL Tutorial
2. System Packages
3. dbms_preprocessor

SQL>
SQL> CREATE OR REPLACE PROCEDURE post_processed
  2  IS
  3  BEGIN
  4  $IF $$PLSQL_OPTIMIZE_LEVEL = 1
  5  $THEN
  6     -- Slow and easy
  7     NULL;
  8  $ELSE
  9     -- Fast and modern and easy
 10     NULL;
 11  $END
 12  END post_processed;
 13  /

Procedure created.

SQL>
SQL> BEGIN
  2     dbms_preprocessor.print_post_processed_source ('PROCEDURE', USER, 'POST_PROCESSED');
  3  END;
  4  /

PL/SQL procedure successfully completed.