[Oracle] 버전 확인

[오라클 버전확인 쿼리]

 

1) 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 HPUX: Version 11.2.0.4.0 - Production
NLSRTL Version 11.2.0.4.0 - Production

 

 

2) select product, version from sys.product_component_version;

 

PRODUCT    VERSION

--------------------------------------------------------------------------------

NLSRTL                                              11.2.0.4.0
Oracle Database 11g Enterprise Edition     11.2.0.4.0
PL/SQL                                               11.2.0.4.0
TNS for HPUX:                                     11.2.0.4.0