[SQL Utility] How to retrieve Oracle’s version info?

1. v$version

  

SQL> desc v$version;
Name
                                                                       Null?    Type
-------------------------------------------------------------------------------------------------
BANNER                                                                     VARCHAR2(64)
                                                                               

SQL> select * from v$version where rownum = 1;

BANNER
----------------------------------------------------------------
Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 – Prod

 

SQL> select * from v$version;

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

 

 

2. v$instance

 

SQL> desc v$instance;
 

   

Name                                                                   Null?    Type
------------------------------------------------------------------------------------------------

INSTANCE_NUMBER
                                                                                NUMBER
INSTANCE_NAME
                                                                                VARCHAR2(16)
HOST_NAME
                                                                                VARCHAR2(64)
VERSION
                                                                                VARCHAR2(17)
STARTUP_TIME
                                                                                DATE
STATUS
                                                                                VARCHAR2(12)
PARALLEL
                                                                                VARCHAR2(3)
THREAD#
                                                                                NUMBER
ARCHIVER
                                                                                VARCHAR2(7)
LOG_SWITCH_WAIT
                                                                                VARCHAR2(15)
LOGINS
                                                                                VARCHAR2(10)
SHUTDOWN_PENDING
                                                                                VARCHAR2(3)
DATABASE_STATUS
                                                                                VARCHAR2(17)
INSTANCE_ROLE
                                                                                VARCHAR2(18)
ACTIVE_STATE
                                                                                VARCHAR2(9)
BLOCKED
                                                                                VARCHAR2(3)

SQL> select version from v$instance;

VERSION
-----------------
10.2.0.4.0