Re: patch level and version of db?

"Roger" <rwestbrook_at_dollargeneral.com> wrote in message news:16e6a39.0111140832.47afb3d8_at_posting.google.com...
> How can I tell patch level and version of my database?
>
> We have 11 different installations at various patch levels. I'm
> looking for a method I can give to our developers to enable them to
> tell what db version and patch level a given instance is at. Is there
> a table or o/s file they can inquire against to get the current db
> version and patch level?
>
> Thanks in advance!
>
> Oh and we're talking Oracle 8x and 9x databases on Unix systems.
>
> Roger Westbrook

select * from v$version.
The first three digits are the version, the last two the O/S specific patch level.

Hth

--
Sybrand Bakker
Senior Oracle DBA

to reply remove '-verwijderdit' from my e-mail address