$IF $$plsql_optimize_level IS NULL OR $$plsql_optimize_level IS NOT NULL : PLSQL_OPTIMIZE_LEVEL « SQL PLUS Session Environment « Oracle PL/SQL Tutorial






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>








29.48.PLSQL_OPTIMIZE_LEVEL
29.48.1.Check $$PLSQL_OPTIMIZE_LEVEL
29.48.2.$IF $$plsql_optimize_level
29.48.3.$IF $$plsql_optimize_level IS NULL OR $$plsql_optimize_level IS NOT NULL