Check Oracle Version
There are several ways where you can query or retrieve the version number of installed Oracle products:
1. If you just want to check the version information of the Oracle database, simply connect and login to the Oracle database with SQL *Plus. Upon login, you will see:
SQL*Plus: Release 9.2.0.6.0 - Production on Tue Oct 18 17:58:57 2005
Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
Connected to:
Oracle9i Enterprise Edition Release 9.2.0.6.0 - 64bit Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.6.0 - Production
The first italic number is the version of the SQL*Plus client and the second italic number is the version of Oracle database which you are connected to .
2. Retrieve the version information from v$version table by using SQL*Plus. 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:
Banner
————————————————————————————–
Oracle9i Enterprise Edition Release 9.2.0.1.0 - 64bit Production
3. Version information can also be checked from Installed Products from the Oracle Universal Installer. It will tells you what products is installed on the machine and also its version information too.
In Unix, the installer is located at $ORACLE_HOME/bin/runInstaller.
In Windows, access the installer by Start -> All Programs -> Oracle Installed Products -> Universal Installer.
Share and contribute or get technical support and help at My Digital Life Forums.
Related Articles
- How to Check the Firmware Version of iPhone
- Check Cisco Switch Version and Hardware
- How to Check if Windows Vista, XP and 2003 System Is 32-bit or 64-bit (x86 or x64) Version
- Oracle Database Link
- Oracle JDeveloper Reviews
- IMP-00013 Oracle Import Error
- How to Escape Characters in Oracle PL/SQL Queries
- Oracle PL/SQL ORA-00947 Not Enough Values Error
- Manual and Clean Uninstall Oracle for Windows
- Insert Text Literal and Concatenation in Oracle SQL
Entries (RSS)
March 3rd, 2008 22:29
It was a very helpful to find the oracle version information through sqlplus.
Thanks,
pankaj
August 13th, 2008 06:16
select * from versions;
The above SQL will do.
August 13th, 2008 19:03
The above query will not work in oracle
use the below query
Select * from v$version;
September 12th, 2008 04:35
If anyone gets an “invalid character” error after copy & pasting in the query from the article:
select * from v$version where banner like ‘Oracle%’;”
Try replacing the “curly” singlequote characters around “Oracle%” with regular straight singlequotes:
select * from v$version where banner like ‘Oracle%’;
September 12th, 2008 04:39
Apparently this server is automatically replacing straight singlequotes with curly ones, even in my comment! Still, the suggestion from my previous post above still applies; just do the replace on your own local machine, instead of in a comment here.