Re: oracle version via sql

From: Christian Antognini <christian.antognini_at_trivadis.com>
Date: Fri, 17 Sep 2004 18:22:16 +0200
Message-ID: <414b0ff6@post.usenet.com>

Post for FREE via your newsreader at post.usenet.com ****

"Mark" <Scollop027_at_gmx.net> wrote in message news:2quj0sF146ufsU1_at_uni-berlin.de...
> Hello NG,
>
> the current date I can get from dual by selecting sysdate, but how to
> request the oracle version via a sql command ?
>
> thanks and regards
> Mark

Hi Mark

If you need only the version number (i.e. not all information like v$version) you could use the following method:

SQL> variable v varchar2(20)
SQL> variable c varchar2(20)
SQL> exec dbms_utility.db_version(:v,:c)
SQL> print v

9.2.0.1.0

Chris

-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=

Usenet.com - The #1 Usenet Newsgroup Service on The Planet! *** http://www.usenet.com Unlimited Download - 19 Seperate Servers - 90,000 groups - Uncensored -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=

Received on Fri Sep 17 2004 - 11:22:16 CDT