Posted By

mprabhuram on 08/31/10


Tagged

Oracle PLSQL


Versions (?)

Return Database Version


 / Published in: SQL
 

Returns database's version

  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  

You need to login to post a comment.