Re: getting instance-name

Hi,

The result part before the firt dot of :  "select global_name from global_name;" will match I think.

Harald Mitterhofer a écrit :
>
> hi!
>
> is there a way to query the instance-name of the database in a
> pl/sql-procedure running as a normal (non-dba-privileged) user?
> I guess there is some system-view, but cannot find it;
>
> thanx;
> mitt
 

-- 
Nooredine ISSAC	(IMS/IBS, bureau 312)      e-mail : nissac_at_capgemini.fr
Cap Gemini Telecom France                  tel    : 33 (0)1 49 00 49 78
Tour Europlaza                             fax    : 33 (0)1 49 00 44 24
La Defense 4
20, Avenue Andre Prothin
F92927 La Défense cedex