Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> how to check version of oracle ?

how to check version of oracle ?

From: Norman Dunbar <Norman.Dunbar_at_lfs.co.uk>
Date: Wed, 21 Aug 2002 14:02:33 +0100
Message-ID: <E2F6A70FE45242488C865C3BC1245DA702893BB2@lnewton.leeds.lfs.co.uk>


try :

select banner from v$version;

or

select instance_name,version from v$instance.

:o)

Cheers,
Norman.



Norman Dunbar
Database/Unix administrator
Lynx Financial Systems Ltd.
mailto:Norman.Dunbar_at_LFS.co.uk
Tel: 0113 289 6265
Fax: 0113 289 3146
URL: http://www.Lynx-FS.com

-------------------------------------

-----Original Message-----
From: dragon ball [mailto:perseus_medusa_at_hotmail.com] Posted At: Wednesday, August 21, 2002 1:38 PM Posted To: server
Conversation: how to check version of oracle ? Subject: how to check version of oracle ?

HI all ,

    How can I check the version of an oracle instance ?

    Thanks.

Perseus Received on Wed Aug 21 2002 - 08:02:33 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US