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