Expert: Suchitra Joshi - 10/7/2009

Question
what are the differences between oracle 10g and 11g version?
how can i check version of oracle from command prompt?  

Answer
Hi Debasis,

1) You can check the Oracle 11g features so that you can identify the differences with 10g for each line -

http://mhabib.wordpress.com/2007/03/31/oracle-11g-new-features/


2) To check version of oracle from command prompt, if you are using unix, you can type sqlplus. It will connect to Oracle and show the corresponding version
eg.
Connected to:
Oracle8i Enterprise Edition Release 8.1.6.3.0 - Production
With the Partitioning option
JServer Release 8.1.6.3.0 - Production

Or

You can use TOAD/SQLplus to connect to the database and enter either of the following queries -

select * from v$version;
select * from v$instance;


Hope this helps.

Regards

Suchitra