Determine the Oracle Database Version

If you are looking for Oracle database version, use the below command.

SQL> SELECT * from V$VERSION;

BANNER
-------------------------------------------------------------------------------

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 64-bit Windows: Version 11.2.0.1.0 - Production
NLSRTL Version 11.2.0.1.0 - Production

Alternatively, you can refer to V$INSTANCE: Display Oracle Database & Instance State for the version.

1 Comment