Re: Database Version

From: Sameer Deshpande <sameer_deshpande_at_hotmail.com>
Date: 24 Aug 2005 07:36:56 -0700
Message-ID: <1124894216.481664.243750@g14g2000cwa.googlegroups.com>

Thanks a lot for the replies..

Though version.v$instance has correct information, I cant use this because this needs privileged user. Possibly thought of using v$version again by restricting rownum = 1 As the first row always returns database version. Later by putting some reg expression around the first rows result to get 5 digit version number.

Sameer

Sameer Deshpande wrote:
> Hi,
>
> Is there any data dictionary which gives short version description of
> database?
>
> I do not want to query v$version, because v$version gives me detailed
> info. I just need a short description of db version like 9.2.0.4
>
> Thanks
>
> Sameer
Received on Wed Aug 24 2005 - 09:36:56 CDT