Re: oracle version via sql

From: Pete Finnigan <plsql_at_petefinnigan.com>
Date: Fri, 17 Sep 2004 10:17:50 +0100
Message-ID: <udY39GB+uqSBRxjj@peterfinnigan.demon.co.uk>

In article <2quj0sF146ufsU1_at_uni-berlin.de>, Mark <Scollop027_at_gmx.net> writes
>Hello NG,
>
>the current date I can get from dual by selecting sysdate, but how to
>request the oracle version via a sql command ?
Hi Mark,

You can do it from the view v$version. This view is publicly accessible and you can simply select :-

SQL> select banner
  2 from v$version;

BANNER

---

Personal Oracle9i Release 9.2.0.1.0 - Production PL/SQL Release 9.2.0.1.0 - Production
CORE 9.2.0.1.0 Production
TNS for 32-bit Windows: Version 9.2.0.1.0 - Production NLSRTL Version 9.2.0.1.0 - Production

SQL> Kind regards

Pete

-- 
Pete Finnigan
email:pete_at_petefinnigan.com
Web site: http://www.petefinnigan.com - Oracle security audit specialists
Book:Oracle security step-by-step Guide - see http://store.sans.org for details.

Received on Fri Sep 17 2004 - 04:17:50 CDT