Re: selecting name of instance

From: Ana C. Dent <anacedent_at_hotmail.com>
Date: Wed, 11 Jun 2003 18:09:23 -0700
Message-ID: <8pQFa.80181$MJ5.26322@fed1read03>

Harald Maier wrote:
> "Christoph Seidel" <christoph.seidel1_at_gmx.de> writes:
>
>

>>how can i select the name of the instance i'm connected to?
>>
>>e.g. something like "select SID from dual;" or so.

>
>
> I like
>
> select global_name from global_name;

FWIW - not that I'd recommend this, but it is NOT a requirement that GLOBAL_NAME = SID (or anything close to it.)

On the instance of your choice, do
UPDATE GLOBAL_NAME SET GLOBAL_NAME = 'FUBAR'; COMMIT; Now "select global_name from global_name;" and ask yourself if the results match the SID. Received on Wed Jun 11 2003 - 20:09:23 CDT