How to verify that Oracle installation is Enterprise or Standard Edition
Based on the known methods to validate whether a database is SE or EE, they all FAIL to confirm, except the last one, I propose.
select * from v$version;
Oracle Database 11g 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 |
select * from product_component_version;