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: selecting name of instance

Re: selecting name of instance

From: Harald Maier <maierh_at_myself.com>
Date: Wed, 11 Jun 2003 18:40:55 +0200
Message-ID: <m3r860wors.fsf@ate.maierh>


"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;

All users have access to that view.

Harald Received on Wed Jun 11 2003 - 11:40:55 CDT

Original text of this message

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