Oracle PL/SQL - Code for Checking Database Version

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

Description

Code for Checking Database Version

Demo

SQL>
SQL>--  ww  w.  j  av a 2 s  .  c o  m
SQL> BEGIN
  2   $IF DBMS_DB_VERSION.VER_LE_10_1 $THEN  -- selection directive begins
  3     $ERROR 'unsupported database release' $END  -- error directive
  4   $ELSE
  5     DBMS_OUTPUT.PUT_LINE('Release ' || DBMS_DB_VERSION.VERSION || '.' ||DBMS_DB_VERSION.RELEASE || ' is supported.');
  6   COMMIT WRITE IMMEDIATE NOWAIT;
  7   $END  -- selection directive ends
  8  END;
  9  /
Release 11.2 is supported.

PL/SQL procedure successfully completed.

SQL>
SQL>

Related Topic