Re: selecting name of instance

From: Ganesh Raja <ganesh_at_gtfs-gulf.com>
Date: Wed, 11 Jun 2003 21:17:40 +0800
Message-ID: <3ee72c07$1@news.starhub.net.sg>

Select * from V$Instance.

-- 
HTH

Regards,
Ganesh R
"Christoph Seidel" <christoph.seidel1_at_gmx.de> wrote in message
news:bc73g0$g8dtn$1_at_ID-143718.news.dfncis.de...


> Hi,

>

> how can i select the name of the instance i'm connected to?

>

> e.g. something like "select SID from dual;" or so.

>

> TIA

>

>

Received on Wed Jun 11 2003 - 08:17:40 CDT

This message: [ Message body ]
Next message: Ganesh Raja: "Re: How to force db to use spfile?"
Previous message: Ralph: "Bit off topic : It should go faster than this..."
In reply to: Christoph Seidel: "selecting name of instance"
Next in thread: Christoph Seidel: "Re: selecting name of instance"
Reply: Christoph Seidel: "Re: selecting name of instance"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message

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