0. sqlplus (sqlplus 실행)
SQL*Plus: Release 10.2.0.1.0 - Production on Thu Feb 12 14:11:00 2009
Copyright (c) 1982, 2005, Oracle. All rights reserved.
Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining options
1. > select * from PRODUCT_COMPONENT_VERSION
PRODUCT VERSION STATUS
----------------------------------------------------------------------------------------------
NLSRTL 10.2.0.1.0 Production
Oracle9i Enterprise EditionOracle Database 10g Enterprise Edition 10.2.0.1.0 Production
PL/SQL 10.2.0.1.0 Production
TNS for Linux: 10.2.0.1.0 Production
2. > select * from V$VERSION
BANNER
----------------------------------------------------------------
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Prod
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
3. ojdbc14.jar 버전 확인(Oracle JDBC Driver) : jar 압축 풀면 META-INF/MANIFEST.MF에 버전 정보 들어있음.
'DB' 카테고리의 다른 글
| AUDIT - 감사 (0) | 2010.07.30 |
|---|---|
| SQL99 - Insert All, MERGE, IS NAN, INTERVAL (0) | 2010.07.30 |
| Index-Organized Table(IOT), Partitioned Table & Index (0) | 2010.07.30 |
| lock 관련 (0) | 2009.02.27 |
| Oracle Character set 변경 (3) | 2009.02.12 |
| Oracle 실행된 쿼리 보기 (0) | 2009.02.12 |
| user/tablespace sql & export/import (0) | 2009.02.12 |
| Oracle 10g install / client install / uninstall - CentOS 5.2 (0) | 2009.02.12 |