betweenGo

How to Retrieve Oracle Version Information

by on Dec.06, 2006, under Oracle

When you start SQLPlus you should see the Oracle version information. For example:

$ sqlplus fkim/fkim@example

Connected to:
Oracle9i Enterprise Edition Release 9.2.0.1.0 - Production

Also you can execute SQL to retrieve the version information.

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

BANNER
----------------------------------------------------------------
Oracle9i Enterprise Edition Release 9.2.0.1.0 - Production


Share

Related posts:

  1. ORA-12514 and ORA-27101
  2. Catching Oracle exceptions
  3. SQL*Plus Commit on Exit
  4. Viewing Expert-Level Information in the ACC
  5. List users


Leave a Reply

 

Looking for something?

Use the form below to search the site:

Still not finding what you're looking for? Drop a comment on a post or contact us so we can take care of it!