Thursday, August 28, 2008

Queries to find the database version with options intalled

Open Sql*Plus, copy and paste the following contents:

set head off feed off pages 0 serveroutput on

col banner format a72 wrap

select banner
from sys.v_$version;

select ' With the '||parameter||' option'
from sys.v_$option
where value = 'TRUE';

select ' The '||parameter||' option is not installed'
from sys.v_$option
where value <> 'TRUE';

dbms_output.put_line('Port String: '||dbms_utility.port_string);

set head on feed on

No comments: