Oracle PL/SQL Tutorial/SQL PLUS Session Environment/PLSQL OPTIMIZE LEVEL

Check $$PLSQL_OPTIMIZE_LEVEL

   <source lang="sql">

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

 2     l_postproc_code   dbms_preprocessor.source_lines_t;
 3     l_row             PLS_INTEGER;
 4  BEGIN
 5     l_postproc_code := dbms_preprocessor.get_post_processed_source ("PROCEDURE", USER, "POST_PROCESSED");
 6     l_row := l_postproc_code.FIRST;
 7
 8     WHILE (l_row IS NOT NULL)
 9     LOOP
10        DBMS_OUTPUT.put_line (LPAD (l_row, 3)|| " - "|| rtrim ( l_postproc_code (l_row),chr(10)));
11        l_row := l_postproc_code.NEXT (l_row);
12     END LOOP;
13
14  END;
15  /

PL/SQL procedure successfully completed.</source>

$IF $$plsql_optimize_level

   <source lang="sql">

SQL> SQL> CREATE OR REPLACE PROCEDURE check_expressions

 2  IS
 3  BEGIN
 4  $IF $$plsql_optimize_level != 1 OR $$plsql_optimize_level = 2
 5  $THEN
 6     -- Placeholder
 7  $END
 8     NULL;
 9  END check_expressions;
10  /

Procedure created.</source>

$IF $$plsql_optimize_level IS NULL OR $$plsql_optimize_level IS NOT NULL

   <source lang="sql">

SQL> CREATE OR REPLACE PROCEDURE check_expressions

 2  IS
 3  BEGIN
 4
 5  $IF $$plsql_optimize_level IS NULL OR $$plsql_optimize_level IS NOT NULL
 6  $THEN
 7     -- Placeholder
 8  $END
 9     NULL;
10  END check_expressions;
11  /

Procedure created. SQL></source>