Advanced Search

Return Database Version

/ Published in: SQL
Save to your folder(s)
Returns database's version

Expand | Embed | Plain Text

Copy this code and paste it in your HTML 
  1. SET serveroutput ON
  2.  
  3. DECLARE
  4.  ver    VARCHAR2(100);
  5.  compat VARCHAR2(100);
  6. BEGIN
  7.   dbms_utility.db_version(ver, compat);
  8.   dbms_output.put_line('Version: ' || ver ||' Compatible: ' || compat);
  9. END;
  10. /

Report this snippet


Comments

You need to login to view comments.