INSTALL된 ORACLE PRODUCT 및 VERSION 확인 SCRIPT

set echo off

set feedback off

set verify off

set linesize 79

set pagesize 100

col banner format a70 heading "Oracle Versions"

col PRODUCT format a30 heading "Products Installed"

col VERSION format a15

col STATUS format a15

col parameter format a50 heading "Options Installed"

col value format a10 heading "True/False"

col TODAY NEW_VALUE _DATE

set termout off

select to_char(SYSDATE,'fmMonth DD, YYYY') TODAY from DUAL;

set termout on

TTITLE left _DATE CENTER "Oracle Version and Options Installed" Skip 1 -

CENTER "=====================================" skip 2

select banner

from v$version;

ttitle off

select * from product_component_version;

select parameter, value

from v$option;

set verify on

set echo on

set feedback on