How to view the Oracle database version

Method 1: v $ versionSQL> select * from v $ version; www.2cto.com BANNER implements Oracle Database 11g Enterprise Edition Release 11.1.0.7.0-64bit Production PL/SQL Release 11.1.0.7.0-Production CORE 11.1.0.7.0 Production TNS for Linux: Version 11.1.0.7.0-Production NLSRTL Version 11.1.0.7.0-Production Method 2: product_component_versio NSQL> select * from product_component_version; www.2cto.com product version status history NLSRTL 11.1.0.7.0 Production Oracle Database 11g Enterprise Edition 11.1.0.7.0 64bit Production PL/SQL 11.1.0.7.0 Production TNS for Linux: 11.1.0.7.0 Production SQL> method 3: dbms_output.put_line (dbms_db_version.version) SQL> Set serveroutput on SQL> EXEC dbms_output.put_line (dbms_db_version.version); 11 www.2cto.com PL/SQL procedure successfully completed. SQL> Fenng previously conducted a survey on database version usage. It can be seen that at present, there are still a vast majority of databases using the 10gR2 version in China.