Skip to content

Instantly share code, notes, and snippets.

@adintegra

adintegra/OracleStuff.sql

Last active January 4, 2016 10:36
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save adintegra/5cb18fd669fa102df042 to your computer and use it in GitHub Desktop.
Save adintegra/5cb18fd669fa102df042 to your computer and use it in GitHub Desktop.
Download ZIP
Generally useful Oracle snippets
Raw
OracleStuff.sql
-- Basic DB version info
DECLARE
ver VARCHAR2(30);
compat VARCHAR2(30);
BEGIN
dbms_utility.db_version(ver, compat);
dbms_output.put_line('Version: ' || ver || ' Compat: ' || compat);
END;
/
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment