Re: -- name of curent instance

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...