分类: Oracle

查看oracle数据库(database)的版本命令

sqlplus或控制台中下输入以下任意一个语句

SQL> select * from v$version;

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


SQL> select version from v$instance;

VERSION
----------------------------------
11.2.0.1.0


SQL> Select version FROM Product_component_version   Where SUBSTR(PRODUCT,1,6)='Oracle';

VERSION
--------------------------------------------------------------------------------
11.2.0.1.0

相关文章

发表新评论