Re: oracle version via sql

What version of the database is an interesting question.

Maybe two questions need to be asked, that is what version of the oracle server is running the database and also what version are the catalog views in the database as it is possible to have two different versions if you start the database from the wrong ORACLE_HOME.

eg
select banner from v$version ;

Oracle9i Enterprise Edition Release 9.2.0.3.0 - Production PL/SQL Release 9.2.0.3.0 - Production
CORE 9.2.0.3.0 Production
TNS for Solaris: Version 9.2.0.3.0 - Production NLSRTL Version 9.2.0.3.0 - Production

can be different to

SELECT comp_name, version, status FROM dba_registry;

Oracle9i Catalog Views       9.2.0.5.0 VALID
Oracle9i Packages and Types  9.2.0.5.0 VALID
Oracle Text                  9.2.0.5.0 VALID

on the same instance.

"Pete Finnigan" <plsql_at_petefinnigan.com> wrote in message news:udY39GB+uqSBRxjj_at_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 Sun Sep 19 2004 - 22:57:35 CDT