INFOSEC

Find Oracle DB Version using Sql

Connect DB and run this sql
select * from v$version;

It will return version detail like:
Oracle Database 11g Enterprise Edition Release 11.1.0.6.0 - Production
PL/SQL Release 11.1.0.6.0 - Production
"CORE 11.1.0.6.0 Production"
TNS for Linux: Version 11.1.0.6.0 - Production
NLSRTL Version 11.1.0.6.0 - Production

posted by Nishidhdha @ 8:16 AM