Version of oracle database

How to know version of your oracle database?

To know version In sql prompt try any of below queries :

SQL>  select *  from PRODUCT_COMPONENT_VERSION PRODUCT                        VERSION      STATUS ------------------------      ------------ --------------- NLSRTL                               11.2.0.1.0    Production Oracle Database 11g             11.2.0.1.0   64bit Production  Enterprise Edition PL/SQL                                11.2.0.1.0   Production TNS for Linux:                      11.2.0.1.0   Production

Or

SQL> SELECT version FROM V$INSTANCE; VERSION ------------ 11.2.0.1.0

Or

SQL> select version from dba_registry; VERSION ------------------------------ 11.2.0.4.0 11.2.0.4.0

  
Or

SQL> select * from v$version; BANNER -------------------------------------------------------------------------------- Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production PL/SQL Release 11.2.0.1.0 - Production CORE    11.2.0.1.0      Production TNS for Linux: Version 11.2.0.1.0 - Production NLSRTL Version 11.2.0.1.0 - Production