RE: [LUG] Query version of Oracle

["Hatton, Peter" <Peter.Hatton@xxxxxxxx>]

Title: RE: [LUG] Query version of Oracle

The easiest way to find out the version of oracle running is to start SQL Plus from the Oracle tools, and enter the username, password and the hoststring. (If they are available to you)  The command line program is sqlplus, but it's been a while since I've done oracle on a unix/linux box.

Normally, SQL plus reports the version it's running, but if it doesn't type this command into SQL plus.

select * from v$version
where banner like 'Oracle%';

Hope that helps.

Pete Hatton

-----Original Message-----
From: owner-list@xxxxxxxxxxxx [mailto:owner-list@xxxxxxxxxxxx]On Behalf
Of Alex Stanley
Sent: 12 January 2004 17:20
To: list@xxxxxxxxxxxx
Subject: [LUG] Query version of Oracle

Is there any way I can find out the version of Oracle running on a RedHat box? 
I'm *not* an Oracle expert by any stretch of the imagination... :)

Thanks

Alex.

--
The Mailing List for the Devon & Cornwall LUG
Mail majordomo@xxxxxxxxxxxx with "unsubscribe list" in the
message body to unsubscribe.