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

Home -> Community -> Mailing Lists -> Oracle-L -> Instance Name in Sql Prompt

Instance Name in Sql Prompt

From: Ramon Estevez <com.banilejas_at_codetel.net.do>
Date: Thu, 25 Oct 2001 06:34:08 -0700
Message-ID: <F001.003B42CC.20011025063521@fatcity.com>

Hi
Friends,
<SPAN

class=578542714-25102001> 
Excuse me for this dumb
question,  how do I display the instance name in the sql prompt.  Have 3
DB and would like to know to which one I am connected.
<SPAN

class=578542714-25102001> 
I mean something like
that.
<SPAN

class=578542714-25102001> 
DBA1
>
DBA2
>
DB01
>
<SPAN

class=578542714-25102001> 
<SPAN

class=578542714-25102001>Regards,
<SPAN

class=578542714-25102001> 
Ramon E.
Estevez
<A

href="">com.banilejas_at_codetel.net.do
Dominican Republic
809-565-3121
  Received on Thu Oct 25 2001 - 08:34:08 CDT

Original text of this message

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