Re: Can you tell an Oracle Patch ??

From: <scjonson_at_my-deja.com>
Date: 2000/06/28
Message-ID: <8jd9bo$h40$1@nnrp1.deja.com>#1/1

Try:
SQL> select * from v$version;

BANNER

---

Oracle8i Enterprise Edition Release 8.1.5.0.1 - Production PL/SQL Release 8.1.5.0.0 - Production
CORE Version 8.1.3.0.0 - Production
TNS for Linux: Version 8.1.5.0.0 - Production NLSRTL Version 3.4.0.0.0 - Production

The 4th decimal is the patch set.

hth
Steve...

In article <8jctug$7e8$1_at_nnrp1.deja.com>,   sjoshi_at_ingr.com wrote:
> Hello All
> I was wondering if Oracle records internally any patches that are
> applied. I need a way to figure out if a user has installed the latest
> patch. Is this possible ?
>
> thanks
> Sunit
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
>

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Wed Jun 28 2000 - 00:00:00 CDT