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