Oracle Forum - The Knowledge Center for Oracle Professionals - Looking Beyond the Possibilities

Full Version: Query- How to check the Oracle database version
You're currently viewing a stripped down version of our content. View the full version with proper formatting.
How can We check, what is the version of database am using ?
You can try:
Code:
SELECT * FROM V$VERSION
or
Code:
SELECT version FROM V$INSTANCE
or
Code:
BEGIN DBMS_OUTPUT.PUT_LINE(DBMS_DB_VERSION.VERSION || '.' || DBMS_DB_VERSION.RELEASE); END;