AllExperts > Oracle 
Search      
Oracle
Volunteer
Answers to thousands of questions
 Home · More Oracle Questions · Answer Library  · Encyclopedia ·
More Oracle Answers
Question Library

Ask a question about Oracle
Volunteer
Experts of the Month
Expert Login

Awards

About Us
Tell friends
Link to Us
Disclaimer

 
 
 
 
About Suchitra Joshi
Expertise
I can answer questions regarding SQL, PL/SQL, Procedures, Functions, Triggers, SQL Loader, Oracle Forms, Oracle Reports, and some basic dba and performance tuning activities.

Experience
15+ years of Oracle PL/SQL Development

Education/Credentials
B.Sc (Electronics), Diploma in Computer Applications (DCA)

Awards and Honors
OCP - SQL and PL/SQL
Brainbench certifications in Oracle Administration, PL/SQL, Developer 2000

 
   

You are here:  Experts > Computing/Technology > Oracle > Oracle > oracle

Oracle - oracle


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  

Add to this Answer   Ask a Question


 
User Agreement | Privacy Policy | Kids' Privacy Policy | Help
Copyright  © 2008 About, Inc. AllExperts, AllExperts.com, and About.com are registered trademarks of About, Inc. All rights reserved.