Find version of Oracle

~ sqlandplsql

How to find what version of Oracle you are running.

Method 1 : Connect to sqlplus 

After connecting to sqlplus you can see a welcome message. See below snapshot

Connect sqlplus

You can see I have connected to Oracle 11.2.0.1.0  64 bit version

Method 2 : Using SQL

Run below sql

select * from v$version;

Find Oracle Version

 

 

Advertisements

Published by sqlandplsql

To learn more about the Oracle, SQL, PL SQL, Performance Tuning, Database Modeling, Ubuntu, MySQL etc .Suggestions, comments, feedbacks and referrals are highly appreciated.

Leave a Reply

Fill in your details below or click an icon to log in:

Gravatar
WordPress.com Logo

You are commenting using your WordPress.com account. ( Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. ( Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. ( Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. ( Log Out /  Change )

w
Cancel

Connecting to %s