View version number (database, operating system)

Oracle Check Version number

Oracle is a powerful database, how do we look at its version?

Tools/Raw Materials Oracle database, Sqlplus

Method/Step First Enter Sqlplus,cmd---plsql, login to our users, such as: User/[email protected] DB instance ID, proposed to use the SYSDBA permissions of the account login, will not be able to look at my previous article.

Method One: V$version sql> select * from V$version;

Method Two: Product_component_version sql> select * from Product_component_version;
Method Three: Dbms_output.put_line (dbms_db_version.version) sql> SET serveroutput on sql> EXEC dbms_output.put_line (dbms_  Db_version.version); END

Note SQL statements are semicolon-delimited.