Getting current instance name with a select ?

Hello,

Is there a way to get the currently connected instance, using a select ?

Something like : SELECT USER FROM DUAL;

V_$ACTIVE_INSTANCES is empty.
There's the table V$INSTANCE. I got the good information in INSTANCE_NAME but could this table have several records ?

Any help would be appreciated.

Thanks

Christian Received on Thu Sep 19 2002 - 05:48:48 CDT