Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: -- name of curent instance

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@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 - 15:58:16 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US