Retrieve Oracle version information

Question: How do I check the Oracle version from the command prompt?

Answer: Version information is stored in a table called v$version. In this table you can find version information on Oracle, PL/SQL, etc.

To retrieve the version information for Oracle, you execute the following SQL statement:

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

It should return something like this:

Oracle9i Enterprise Edition Release – 64bit Production

Leave a comment

Leave a Reply

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

You are commenting using your 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 )

Google+ photo

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

Connecting to %s

  • Categories

  • Advertisements
%d bloggers like this: