Wednesday, August 24, 2011

Finding Oracle DB Version

How do you find the Oracle DB version using SQL query?
Connect to the Oracle DB and run following SQL Query:

select * from v$version

Typical output:
Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bi
PL/SQL Release 10.2.0.4.0 - Production
"CORE 10.2.0.4.0 Production"
TNS for Linux: Version 10.2.0.4.0 - Production
NLSRTL Version 10.2.0.4.0 - Production

0 Comments:

Post a Comment

<< Home