Re: Is there a way to determine whether a patch is insalled and it's version?

macbethh_at_iname.com (Robert) wrote in message news:<e6a1a9.0202210529.505ddcdc_at_posting.google.com>...
> Is there a way to determine whether a patch is insalled and it's version,
> on oracle?

select * from v$version;

This usually does the trick. Also there is an inventory file stored in ORACLE_HOME (I cannot remember where exactly) that generally lists the components installed. Also when you log into sqlplus you can get the version number from the header information that is displayed. Most of this assumes that you running 8 or 8i - in these later versions Oracle finally made the version number on their products the same. In Oracle 7.3 and such the sqlplus version was 3.3 (or something like that), so it was hard to tell.

Good luck. Received on Thu Feb 21 2002 - 23:51:54 CET