Oracle 12c常用命令集合

查询当前数据库的详细版本号: 

1.4.2 Checking Your Current Release Number

To identify the release of Oracle Database that is currently installed and to see the release levels of other database components you are using, query the data dictionary view PRODUCT_COMPONENT_VERSION.

A sample query follows. (You can also query the V$VERSION view to see component-level information.) Other product release levels may increment independent of the database server.

SQL> SELECT * FROM V$VERSION;

BANNER                                                                               CON_ID
-------------------------------------------------------------------------------- ----------
Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production              0
PL/SQL Release 12.2.0.1.0 - Production                                                    0
CORE	12.2.0.1.0	Production                                                                  0
TNS for 64-bit Windows: Version 12.2.0.1.0 - Production                                   0
NLSRTL Version 12.2.0.1.0 - Production                                                    0


SQL> SELECT * FROM PRODUCT_COMPONENT_VERSION;

PRODUCT                                                                          VERSION                                                                          STATUS
-------------------------------------------------------------------------------- ----------
NLSRTL                                                                           12.2.0.1.0                                                                       Production
Oracle Database 12c Enterprise Edition                                           12.2.0.1.0                                                                       64bit Production
PL/SQL                                                                           12.2.0.1.0                                                                       Production
TNS for 64-bit Windows:                                                          12.2.0.1.0                                                                       Production

 

©️2020 CSDN 皮肤主题: 编程工作室 设计师:CSDN官方博客 返回首页