Oracle PL/SQL - PLSQL_CCFLAGS Assigns Value to Itself

  1. HOME
  2. Oracle PL/SQL
  3. PL SQL Statement
  4. Preprocessor Control Tokens

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--  w ww. ja va 2  s. c o  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