查看Oracle数据库版本

方法一：

SQL> select * from v$version

BANNER
----------------------------------------------------------------

Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Prod
PL/SQL Release 10.2.0.1.0 - Production
CORE 10.2.0.1.0 Production
TNS for Linux: Version 10.2.0.1.0 - Production
NLSRTL Version 10.2.0.1.0 - Production

方法二：

  SQL>  select * from product_component_version;

PRODUCT                                          VERSION          STATUS
------------------------------------------- ---------------- ----------------
NLSRTL                                           10.2.0.1.0       Production
Oracle Database 10g Enterprise Edition           10.2.0.1.0       Prod
PL/SQL                                           10.2.0.1.0       Production
TNS for Linux:                                   10.2.0.1.0       Production