【Data Platform】/Oracle

[10g] 오라클 버전 확인

디비랑 2011. 8. 22. 17:53
/********************************************************************************************
-- Title : [10g] 오라클 버전 확인
-- Reference : 웹검색
-- Key word : oracle version v$version
********************************************************************************************/

SQL> select * from v$version;
BANNER                                                          
----------------------------------------------------------------
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - 64bi
PL/SQL Release 10.2.0.1.0 - Production                         
CORE 10.2.0.1.0 Production                                     
TNS for Linux: Version 10.2.0.1.0 - Production                 
NLSRTL Version 10.2.0.1.0 - Production