Return to Snippet

Revision: 31169
at August 31, 2010 12:26 by mprabhuram


Initial Code
set serveroutput on

DECLARE
 ver    VARCHAR2(100);
 compat VARCHAR2(100);
BEGIN
  dbms_utility.db_version(ver, compat);
  dbms_output.put_line('Version: ' || ver ||' Compatible: ' || compat);
END;
/

Initial URL


Initial Description
Returns database's version

Initial Title
Return Database Version

Initial Tags
Oracle

Initial Language
SQL