查看oracle的版本信息
用客户端连接到数据库,执行select * from v$instance(查看version项)
···
SELECT * FROM PRODUCT_Component_version
PRODUCT | VERSION | STATUS |
---|---|---|
NLSRTL | 11.2.0.1.0 | Production |
Oracle Database 11g Enterprise Edition | 11.2.0.1.0 | 64bit Production |
PL/SQL | 11.2.0.1.0 | Production |
TNS for 64-bit Windows: | 11.2.0.1.0 | Production |
···
SELECT * FROM V$VERSION查看组件级信息