View Oracle version information (two methods) __oracle

Before looking at Oracle's version information, you know only one way to use the V$versions view, as follows:

Sql> select * from V$version;

BANNER
----------------------------------------------------------------
Oracle9i Enterprise Edition Release 9.2.0.1.0-production
Pl/sql Release 9.2.0.1.0-production
CORE 9.2.0.1.0 Production
TNS for 32-bit windows:version 9.2.0.1.0-production
Nlsrtl Version 9.2.0.1.0-production


I learned another way to http://download-west.oracle.com/docs/cd/B10501_01/server.920/a96521/dba.htm#13306 today: Query the data Dictionary view product_component_version, as follows:


Sql> Col Product format A35
Sql> Col version format A15
sql> Col Status Format A15
Sql> select * from Product_component_version;

PRODUCT VERSION STATUS
----------------------------------- 　　　--------------- ---------------
Nlsrtl 9.2.0.1.0 Production
Oracle9i Enterprise Edition 9.2.0.1.0 Production
Pl/sql 9.2.0.1.0 Production
TNS for 32-bit windows:9.2.0.1.0 Production


It's important to convey to Oracle the information displayed by this query as you are problems with the software