Tag Archives: v$version

What version of Oracle is running

Leave a reply

What version of Oracle is running?

select * from V$VERSION;

Another Option is to use the product table

set lines 200 
column product format a50
column version format a15
column status format a20
SELECT * FROM product_component_version ;

These are examples of running the  SELECT * FROM V$VERSION;  from different versions Oracle would be 

 

The resultant banner will show the current Oracle Database Edition if the Enterprise Edition is installed.

SQL> select * from v$version;

BANNER
----------------------------------------------------------------
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Prod
PL/SQL Release 10.2.0.1.0 - Production
CORE 10.2.0.1.0 Production
TNS for 32-bit Windows: Version 10.2.0.1.0 - Production
NLSRTL Version 10.2.0.1.0 - Production

The resultant banner will show the current Oracle Database Edition if the Standard Edition is installed.

SQL> select * from v$version;

BANNER
----------------------------------------------------------------
Oracle Database 10g Release 10.2.0.1.0 - Production
PL/SQL Release 10.2.0.1.0 - Production
CORE    10.2.0.1.0 Production
TNS for 32-bit Windows: Version 10.2.0.1.0 - Production
NLSRTL Version 10.2.0.1.0 - Production

The resultant banner will show the current Oracle Database Edition if the Personal Edition is installed.

SQL> SELECT * FROM V$VERSION;

BANNER
----------------------------------------------------------------
Personal Oracle Database 10g Release 10.2.0.1.0 - Production
PL/SQL Release 10.2.0.1.0 - Production
CORE 10.2.0.1.0 Production
TNS for 32-bit Windows: Version 10.2.0.1.0 - Production
NLSRTL Version 10.2.0.1.0 - Production