Oracle Forum - The Knowledge Center for Oracle Professionals - Looking Beyond the Possibilities
Query- How to check the Oracle database version - Printable Version

+- Oracle Forum - The Knowledge Center for Oracle Professionals - Looking Beyond the Possibilities (http://www.oraerp.com)
+-- Forum: Oracle Applications (http://www.oraerp.com/forum-39.html)
+--- Forum: Oracle Tutorials, Articles, eBooks, Tools & Tips (http://www.oraerp.com/forum-12.html)
+--- Thread: Query- How to check the Oracle database version (/thread-71461.html)

Query- How to check the Oracle database version - Zishan Ali - 08-17-2015

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;