HPE Community
Operating System - HP-UX
1753316 Members
5413 Online
108792 Solutions
New Discussion юеВ

Re: What version of Oracle am I running

 
SOLVED
Go to solution
Yogeeraj_1
Honored Contributor

тАО09-02-2004 03:34 AM

тАО09-02-2004 03:34 AM

Re: What version of Oracle am I running

hi,

querying the v$version should give you the exact version.

e.g.
yd@MYDB.MU> select * from v$version;

BANNER
________________________________________________________________
Oracle8i Enterprise Edition Release 8.1.7.4.0 - 64bit Production
PL/SQL Release 8.1.7.4.0 - Production
CORE 8.1.7.0.0 Production
TNS for HPUX: Version 8.1.7.4.0 - Production
NLSRTL Version 3.4.1.0.0 - Production

5 rows selected.

Elapsed: 00:00:00.03
yd@MYDB.MU>

regards
Yogeeraj
No person was ever honoured for what he received. Honour has been the reward for what he gave (clavin coolidge)
0 Kudos
Emilio Brusa
Frequent Advisor

тАО09-03-2004 03:45 AM

тАО09-03-2004 03:45 AM

Re: What version of Oracle am I running

Hi,
In SQlplus

select * from v$version

E.

0 Kudos
Ratzie
Super Advisor

тАО02-23-2005 01:09 AM

тАО02-23-2005 01:09 AM

Re: What version of Oracle am I running

Thanks
0 Kudos
The opinions expressed above are the personal opinions of the authors, not of Hewlett Packard Enterprise. By using this site, you accept the Terms of Use and Rules of Participation.