Re: A request to owners of Oracle7.x and 8.0 on unix

On Wed, 25 Aug 2004 13:38:20 +0200, "jd" <jedrzej_dudkiewicz_at_poczta.interia.pl> wrote:

>Greetings,
>
>I'm currently writing a script that detects packages installed along with
>Oracle. Since I can't find downloadable (or any other, in fact) versions of
>Oracle 7.x and 8.0, I'd like to ask those of you, who own such databases, to
>provide me with (probably partial, since it's supposed to be quite long) an
>output of a following command:
>
>
>cat $ORACLE_HOME/unix.prd |\
>awk -F\" '{ printf ("%-40s %-10s %-20s\n", $6, $2, $4) }' |\
>grep '^[^ ]'
>
>
>
>It's supposed to write info that will contain information that I need.
>
>
>
>Thanks in advance,
>
>
>
>JD
>

Same information can be provided by
select * from v$version and select * from v$option.

Also 7.x and 8.0 are dead since the stone age.

--
Sybrand Bakker, Senior Oracle DBA