How to find Oracle’s Database Edition version – Comment trouver la version Edition d’une base de données Oracle.

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

 

 

Leave Comment

Your email address will not be published. Required fields are marked *