Re: Oracle version via SQL

From: Christopher Beck <clbeck_at_us.oracle.com>
Date: Wed, 30 Jun 1999 20:30:05 GMT
Message-ID: <377b7dfb.13241530@inet16.us.oracle.com>

On Wed, 30 Jun 1999 10:54:11 -0800, EG <anonymous_at_web.remarq.com> wrote:

>Actually the subject says it all, but to rephrase it:
>
>Is there a way to identify the version of the Oracle DBMS
>via SQL? I am looking for a way to get that data from a
>PL/SQL block.

try...

SQL> select * from v$version;

BANNER

---

Oracle8i Enterprise Edition Release 8.1.5.0.0 - Production PL/SQL Release 8.1.5.0.0 - Production
CORE Version 8.1.3.0.0 - Production
TNS for Solaris: Version 8.1.5.0.0 - Production NLSRTL Version 3.4.0.0.0 - Production

hope this helps

chris.

>
>Thanks in advance,
>
>Eric
>
>
>
>**** Posted from RemarQ - http://www.remarq.com - Discussions Start Here (tm) ****

--
Christopher Beck
Oracle Corporation
clbeck_at_us.oracle.com
Reston, VA.

---

Opinions are mine and do not necessarily reflect those of Oracle Corporation Received on Wed Jun 30 1999 - 15:30:05 CDT