Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: how to check version of oracle ?
Hi
You can use
"SELECT * FROM V$VERSION"
Salutations
Epicentre Team A
"Norman Dunbar" <Norman.Dunbar_at_lfs.co.uk> wrote in message
news:E2F6A70FE45242488C865C3BC1245DA702893BB2_at_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 - 12:48:26 CDT