Finding the version of database

[Garlands]

HI all ,

I have a simple question against you all whoever getting my question here. I need to find out the which version of oracle database I am using right now.I would like to know what patch I currently have installed. I know I have version 8.1.7.? installed.Is there any particular SQL command through which I can find out that .So please aware me about that.

Thanks

[Reegan]

Finding the version of database :

There are several ways to find out the versions of oracle database.when you execute the specific statement it results the perfect version of current running database.There are three ways to represent the version of oracle database :

1- At start up of database
2- Using dynamic view
3- Using selected columns.

[opaper]

Finding the version at startup :

If you used to check simply the version of running database,you need to login into the database with SQL *Plus utility.As you connect with this utility you get some information from oracle database.

SQL*Plus: Release 9.2.0.6.0 – Production on Tue Jan 18 12:58:00 2010

Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.

[MindSpace]

Using dynamic view :

If you have stated the database and come across the text that you unable to see right now then you can use the provided view
to investigate the version :

The Dynamic view V$version is one of the view which is used to get the desired output,you have to execute the following :

SQL>select * from v$version where banner like ‘Oracle%’;

[Modifier]

Using selected columns :

You can find out the database version the another option is introduced here to check the applied patch of your database.The table name "Product_component_version" is being used and it will show the structure when you fire the description command :

SQL> Desc Product_component_version;

And the value would be represented using the following statement :

SQL> Select * from Product_component_version;