Here is the SQL command that show you important information about Oracle’s engine, such as the edition (Enterprise, Standard, Lite …).
Voici commande sql qui permet d’avoir les infos importantes sur la version du moteur Oracle, notamment l’éditions (Entreprise, Standard, Lite etc …).
SQL> select banner from v$version;
BANNER ---------------------------------------------------------------- Oracle8i Enterprise Edition Release 8.1.7.2.0 - Production PL/SQL Release 8.1.7.2.0 - Production CORE 8.1.7.0.0 Production TNS for DEC OSF/1 AXP: Version 8.1.7.2.0 - Production NLSRTL Version 3.4.1.0.0 - Production
SQL> select banner from v$version;
BANNER ---------------------------------------------------------------- Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - Prod 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