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.
|