由 macro 发布于: 2001-03-03 09:43

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';

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

set head on feed on


resulte screen:

begin

    dbms_output.pu   The Partitioning option is not installed

   The Parallel Server option is not installed

   The Advanced replication option is not installed

   The Bit-mapped indexes option is not installed

   The Database queuing option is not installed

   The Incremental backup and recovery option is not installed

   The Instead-of triggers option is not installed

   The Parallel backup and recovery option is not installed

   The Parallel execution option is not installed

   The Point-in-time tablespace recovery option is not installed

   The Fine-grained access control option is not installed

   The N-Tier authentication/authorization option is not installed

   The Function-based indexes option is not installed

   The Plan Stability option is not installed

   The Online Index Build option is not installed

t   The Coalesce Index option is not installed

   The Managed Standby option is not installed

   The Materialized view rewrite option is not installed

_line(   The Materialized view warehouse refresh option is not installed

   The Database resource manager option is not installed

   The Spatial option is not installed

   The Visual Information Retrieval option is not installed

   The Export transportable tablespaces option is not installed

   The Transparent Application Failover option is not installed

   The Fast-Start Fault Recovery option is not installed

   The Sample Scan option is not installed

   The Duplexed backups option is not installed

'Port String: '||dbms_utility.port_string);

end;