Tuesday, February 21, 2012

Check Oracle Version

You can run below query to get the oracle version you are using

SELECT * FROM v$version

When I try to run this query on my PL/SQL  Developer I get following result

Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
PL/SQL Release 11.2.0.1.0 - Production
CORE    11.2.0.1.0    Production
TNS for Linux: Version 11.2.0.1.0 - Production
NLSRTL Version 11.2.0.1.0 - Production

You may get different information according to the versions you have.Note that this query will also return you some other useful information like TNS ,NJSRTL versions.

I hope this would help someone out there :).

No comments:

Post a Comment