Query to find current version of Oracle

There are two ways to find out the current version of Oracle using sqlplus.

First is is when you start sqlplus, it will display the version. It will look something like this:

SQL*Plus: Release 9.2.0.8.0 - Production on Wed Apr 16 10:06:34 2008
Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
Enter user-name:

Second way is to run following query :

SQL> select * from v$version ;

Connected to:Oracle9i Enterprise Edition Release 9.2.0.8.0 - 64bit ProductionWith the Partitioning optionJServer Release 9.2.0.8.0 - Production