oracle - 从 Oracle 版本获取编号

Question

我有兴趣如何才能只获取 Oracle 版本中的编号？

select * from v$version where banner like 'Oracle%';

BANNER                                                                         
--------------------------------------------------------------------------------
Oracle Database 11g Express Edition Release 11.2.0.2.0 - 64bit Production  


BANNER
--------------------------------------------------------------------------------
    CON_ID
----------
Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production    
         0

Answer 1

方法有很多。

您可以在V$INSTANCE View 中检查VERSION:

SQL> SELECT version FROM V$INSTANCE;

VERSION
-----------------
12.1.0.1.0

您可以在 PRODUCT_COMPONENT_VERSION View 中查看VERSION:

SQL> SELECT VERSION
  2  FROM PRODUCT_COMPONENT_VERSION
  3  WHERE product LIKE '%Oracle Database%';

VERSION
--------------------------------------------
12.1.0.1.0

您可以使用DBMS_DB_VERSION包:

SQL> set serveroutput on
SQL> BEGIN
  2    DBMS_OUTPUT.PUT_LINE(DBMS_DB_VERSION.VERSION || '.' || DBMS_DB_VERSION.RELEASE);
  3  END;
  4  /
12.1

PL/SQL procedure successfully completed.

<小时/>

更新要将产品和版本作为单独的列获取，您可以执行以下操作:

SQL> SELECT product AS edition,
  2         version
  3  FROM PRODUCT_COMPONENT_VERSION
  4  WHERE product LIKE '%Oracle Database%';

EDITION                                  VERSION
---------------------------------------- ----------
Oracle Database 12c Enterprise Edition   12.1.0.1.0