08-17-2015, 12:35 AM
How can We check, what is the version of database am using ?
You can try:
or
or
You can try:
Code:
SELECT * FROM V$VERSIONCode:
SELECT version FROM V$INSTANCECode:
BEGIN DBMS_OUTPUT.PUT_LINE(DBMS_DB_VERSION.VERSION || '.' || DBMS_DB_VERSION.RELEASE); END;