A version message will appear when you enter the database with SQLPLUS.
If you connect to the database after you enter SQLPlus, you can view the database version by the following command:
SQL> SELECT * FROM V $ VERSION;
Banner ------------------------------------- --------------- Oracle9i Enterprise Edition Release 9.2.0.2.0 - 64bit Production PL / SQL Release 9.2.0.2.0 - Production Core 9.2.0.2.0 Production TNS for IBM / AIX RISC System / 6000: Version 9.2.0.2.0 - Production NLSRTL VERSION 9.2.2.2.0 - Production Light View Version Number:
SQL> SELECT VERSION from V $ INSTANCE;
Version ---------------- 9.2.0.2.0
See which features in the current database in the database are installed, which features are not installed:
SQL> SELECT * FROM V $ OPTION;
(There are more output, not listed here)
