Oracle PL/SQL/PL SQL/Conditional compilation
Conditional compilation parameters are stored as name and value pairs in the PLSQL_CCFLAG database parameter
<source lang="sql">
SQL> SQL> BEGIN
2 $IF $$DEBUG = 1 $THEN 3 dbms_output.put_line("Debug Level 1 Enabled."); 4 $END 5 END; 6 /
Debug Level 1 Enabled. PL/SQL procedure successfully completed. SQL>
</source>