오라클 버전 확인

1 방법 1: sqlplus

Copy

oracle@jmnote:/oracle> sqlplus

SQL*Plus: Release 10.2.0.1.0 - Production on 금 2월 1 21:25:06 2013

Copyright (c) 1982, 2005, Oracle.  All rights reserved.

Enter user-name:

2 방법 2: SQL (1)

SQL

sql

Copy

SELECT * FROM v$version WHERE banner LIKE 'Oracle%';

실행결과

◢ 1	BANNER Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Prod

SQL

sql

Copy

SELECT * FROM v$version;

실행결과

◢ 1 2 3 4 5

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 방법 3: SQL (2)

SQL

sql

Copy

SELECT * FROM PRODUCT_COMPONENT_VERSION;

실행결과

◢ 1 2 3 4

PRODUCT VERSION STATUS NLSRTL 10.2.0.1.0 Production Oracle Database 10g Enterprise Edition 10.2.0.1.0 Prod PL/SQL 10.2.0.1.0 Production TNS for Linux: 10.2.0.1.0 Production

4 같이 보기

• MySQL 버전 확인
• PostgreSQL 버전 확인

5 참고 자료

• http://webprogrammer.tistory.com/1199