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 -> Re: Retrieve version information through SQL

Re: Retrieve version information through SQL

From: Ron Reidy <ron_at_indra.com>
Date: Sun, 16 Sep 2001 16:57:45 -0600
Message-ID: <3BA52E69.2FC0E2FE@indra.com>


Andy Hallam wrote:
>
> Hi all.
>
> Could some one please tell me how to retrieve the ORACLE database version
> information
> through an SQL statement (like SELECT @@VERSION on MS SQL SERVER).
>
> Can't find it in the docs anywhere.
>
> thanks in advance.
>
> Andy.
> ahm_at_exel.co.uk

Look at V$INSTANCE

-- 
Ron Reidy
Oracle DBA
Reidy Consulting, L.L.C.
Received on Sun Sep 16 2001 - 17:57:45 CDT

Original text of this message

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