Live ORACLE

rem -----------------------------------------------------------------------

rem File name:   ver.SQL

rem Purpose:    Show database version with options installed

rem             (handy for your HELP/ABOUT menu)

rem Date:       12-Nov-1999

rem Author:     Frank Naude, Oracle faq

rem -----------------------------------------------------------------------

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

Show database version with options installed