Afficher la version de la base oracle

SQL> SELECT * FROM v$version WHERE banner LIKE 'Oracle%';

BANNER
----------------------------------------------------------------
Oracle DATABASE 10g Enterprise Edition Release 10.2.0.4.0 - 64bi

Afficher le temps d'uptime d'une base oracle

SQL> SELECT instance_name,host_name,TO_CHAR(startup_time,'DD-MON-YYY HH:MM:SS AM') FROM v$instance;

INSTANCE_NAME
----------------
HOST_NAME
----------------------------------------------------------------
TO_CHAR(STARTUP_TIME,'DD-MON
----------------------------
NOVA
mrs-db-00011
05-JAN-009 05:01:42 AM