Re: -- name of curent instance
From: Álvaro Palma Aste <queria_direccion_at_el.perla.invalid>
Date: Thu, 11 Jul 2002 20:58:16 +0000 (UTC)
Message-ID: <agkrh8$1v9$1_at_localhost.localdomain>
Date: Thu, 11 Jul 2002 20:58:16 +0000 (UTC)
Message-ID: <agkrh8$1v9$1_at_localhost.localdomain>
En comp.databases.oracle.tools REM escribió:
>How I can get name of CURENT INSTANCE???
>--
>with regards,
>ilica
>_________
>"If A is a success in life, then A equals x plus y plus z. Work is x; y is
>play; and z is keeping your mouth shut."
select name
,value
from v$parameter
where name in
('instance_name','service_names','mts_service','db_name');
You're welcome
-- Atte. Ãlvaro Palma Aste Grupo de Ing. Biomédica Depto. de Ing. Eléctrica - U. de Chile ****************************************************** It's the only form of protest they're allowed I've seen their silent faces scream so loud If they were to speak these words they'd go missing too Another woman on a torture table what else can they do Sting - They Dance Alone...Received on Thu Jul 11 2002 - 22:58:16 CEST