Tuesday, September 14, 2010

Finding Oracle Server Version

Below sql provides the sql version of the Oracle server

select * from v$version

It returns results as below

Oracle Database 11g Enterprise Edition Release - 64bit Production
PL/SQL Release - Production
"CORE Production"
TNS for IBM/AIX RISC System/6000: Version - Production
NLSRTL Version - Production

No comments:

Post a Comment