Mega Code Archive

 

Categories / Oracle PLSQL Tutorial / System Packages

 

Call dbms_utility db_version to get the version and its compatible version

SQL> SQL> set echo on SQL> SQL> declare   2      l_version        varchar2(255);   3      l_compatibility varchar2(255);   4  begin   5      dbms_utility.db_version( l_version, l_compatibility );   6      dbms_output.put_line( l_version );   7      dbms_output.put_line( l_compatibility );   8  end;   9  / 10.2.0.1.0 PL/SQL procedure successfully completed. SQL> SQL> select dbms_utility.port_string from dual; PORT_STRING ---------------------------------------------------------------------------------------------------- IBMPC/WIN_NT-8.1.0