Oracle 查看版本信息

Oracle About 555 words

方法一

SQL：

select * from v$version;

输出：

BANNER
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
PL/SQL Release 11.2.0.4.0 - Production
"CORE 11.2.0.4.0 Production"
TNS for Linux: Version 11.2.0.4.0 - Production
NLSRTL Version 11.2.0.4.0 - Production

SQL:

select * from product_component_version;

输出：

PRODUCT	VERSION	STATUS
NLSRTL	11.2.0.4.0	Production
Oracle Database 11g Enterprise Edition	11.2.0.4.0	64bit Production
PL/SQL	11.2.0.4.0	Production
TNS for Linux:	11.2.0.4.0	Production

Views: 2,905 · Posted: 2019-07-09

———— END ————

Give me a Star, Thanks:)

https://github.com/fendoudebb/LiteNote

扫描下方二维码关注公众号和小程序↓↓↓