查询Oracle版本

方法1:

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

方法2:

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

Leave a Reply

Your email address will not be published. Required fields are marked *

*