Re: getting instance-name

On Thu, 11 May 2000 19:23:37 +0200, Noor嶮ine ISSAC <nissac_at_capgemini.fr> wrote:

Hello,

but "sometime" the global name is not equal to instance name, maybe you could do something on SYS schema :

1. create or replace view instance_name as select instance_name from v$instance;

 2.create public synonym instance_name for instance_name;

    grant select on instance_name to public;

HTH. Violin.
violin.hsiao_at_mail.pouchen.com.tw

>Hi,
>
>The result part before the firt dot of :
> "select global_name from global_name;"
>will match I think.
>
>Harald Mitterhofer a 嶰rit :
>>
>> 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
Received on Fri May 12 2000 - 00:00:00 CDT