Oracle PL/SQL - PLSQL_CCFLAGS Assigns Value to Itself

Introduction

The following code uses PLSQL_CCFLAGS to assign a value to the user-defined inquiry directive $$Some_Flag and to itself.

Demo

SQL>
SQL> ALTER SESSION SET-- from ww w.  j a  va  2 s . co  m
  2  PLSQL_CCFlags = 'Some_Flag:1, Some_Flag:2, PLSQL_CCFlags:0'
  3  /

Session altered.

SQL> BEGIN
  2    DBMS_OUTPUT.PUT_LINE($$Some_Flag);
  3    DBMS_OUTPUT.PUT_LINE($$PLSQL_CCFlags);
  4  END;
  5  /
2
0

PL/SQL procedure successfully completed.

SQL>

Related Topic