Per conoscere la versione di
Oracle in uso si può usare questo comando
PL/SQLSELECT BANNER FROM v$version;
che da un risultato simile a questo
BANNER
--------------------------------------------------
Oracle Database 12c Standard Edition Release 12.2.
0.1.0 - 64bit Production
PL/SQL Release 12.2.0.1.0 - Production
CORE 12.2.0.1.0 Production
TNS for Linux: Version 12.2.0.1.0 - Production
NLSRTL Version 12.2.0.1.0 - Production
oppure questo
COL PRODUCT FORMAT A40
COL VERSION FORMAT A15
COL STATUS FORMAT A16
SELECT * FROM PRODUCT_COMPONENT_VERSION;
che da un risultato simile a questo in forma
tabellarePRODUCT VERSION STATUS
---------------------------------------- --------------- ----------------
NLSRTL 12.2.0.1.0 Production
Oracle Database 12c Standard Edition 12.2.0.1.0 64bit Production
PL/SQL 12.2.0.1.0 Production
TNS for Linux: 12.2.0.1.0 Production