compile by version : DBMS_DB « System Packages « Oracle PL / SQL

1. Oracle PL / SQL
2. System Packages
3. DBMS_DB

compile by version

   
SQL>
SQL> CREATE OR REPLACE PROCEDURE compile_by_version
  2  IS
  3
  4  BEGIN
  5     $IF DBMS_DB_VERSION.VER_LE_10_2
  6     $THEN
  7        DBMS_OUTPUT.PUT_LINE('10.2 and under');
  8     $ELSIF DBMS_DB_VERSION.VER_LE_10_1
  9     $THEN
 10        DBMS_OUTPUT.PUT_LINE('10.1 and under');
 11     $ELSE
 12        DBMS_OUTPUT.PUT_LINE('Not 10g');
 13     $END
 14
 15  END;
 16  /

Procedure created.

SQL>
SQL>
SQL>

   
    
    
  

Related examples in the same category