Method 1: v $ version1.SQLselect * fromv $ version; 2.3.BANNER4. Release 5. OracleDatabase11gEnterpriseEditionRelease11.1.0.7.0
Method 1: v $ version 1. SQL select * from v $ version; 2. 3. BANNER 4. Release 5. Oracle Database 11g Enterprise Edition Release 11.1.0.7.0-64bit Production 6.PL/ SQL Release
Method 1: v $ version
1. SQL> select * from v $ version;
2.
3. BANNER
4 .--------------------------------------------------------------------------------
5. Oracle Database 11g Enterprise Edition Release 11.1.0.7.0-64bit Production
6. PL/SQL Release 11.1.0.7.0-Production
7. CORE 11.1.0.7.0 Production
8. TNS for Linux: Version 11.1.0.7.0-Production
9. NLSRTL Version 11.1.0.7.0-Production
Method 2: product_component_version
1. SQL> select * from product_component_version;
2.
3. PRODUCT VERSION STATUS
4. Timeout .---------------------------------------------------------------------------------------------
5. NLSRTL 11.1.0.7.0 Production
6. Oracle Database 11g Enterprise Edition 11.1.0.7.0 64bit Production
7. PL/SQL 11.1.0.7.0 Production
8. TNS for Linux: 11.1.0.7.0 Production
9.
10. SQL>
Method 3: dbms_output.put_line (dbms_db_version.version)
1. SQL> SET SERVEROUTPUT ON
2. SQL> EXEC dbms_output.put_line (dbms_db_version.version );
3.11
4.
5. PL/SQL procedure successfully completed.
6.
7. SQL>
Fenng previously conducted a survey on database version usage. It can be seen that at present, the vast majority of Chinese regions still use the 10gR2 version.
