How to check the Oracle database version ?
You can know the Oracle Database version by the following way :
login to sqlplus by SYSTEM user OR SYSDBA.
Then Type one of the following command:
login to sqlplus by SYSTEM user OR SYSDBA.
Then Type one of the following command:
1- SELECT * FROM V$VERSIONor
2- SELECT version FROM V$INSTANCEor
3- BEGIN DBMS_OUTPUT.PUT_LINE(DBMS_DB_VERSION.VERSION || '.' || DBMS_DB_VERSION.RELEASE); END;