From com.banilejas@codetel.net.do Thu, 25 Oct 2001 12:08:11 -0700
From: "Ramon Estevez" <com.banilejas@codetel.net.do>
Date: Thu, 25 Oct 2001 12:08:11 -0700
Subject: RE: Instance Name in Sql Prompt
Message-ID: <F001.003B4E5B.20011025121521@fatcity.com>
MIME-Version: 1.0
Content-Type: text/plain



Thanks to 
Kevin and all that reply.
<SPAN 
class=817291220-25102001> 
I noticed 
when doing a connect inside a session.
<SPAN 
class=817291220-25102001> 
This will 
help.
 
Ramon E. 
Estevez
<A 
href="">com.banilejas@codetel.net.do
Dominican Republic
809-565-3121

  <FONT face=Tahoma 
  size=2>-----Mensaje original-----De: root@fatcity.com 
  [mailto:root@fatcity.com]En nombre de Kevin LangeEnviado el: 
  Thursday, 25 October, 2001 11:10 AMPara: Multiple recipients of 
  list ORACLE-LAsunto: RE: Instance Name in Sql 
  Prompt
  <FONT color=#0000ff face=Arial 
  size=2>Ramon;
  <FONT color=#0000ff face=Arial 
  size=2>  In your startup directory on SQL Plus, you can automatically run 
  a script that will setup the environment like you want it.  Its called 
  LOGIN.SQL.
  <FONT color=#0000ff face=Arial 
  size=2> 
  Here 
  is a copy of mine:
  <FONT color=#0000ff face=Arial 
  size=2> 
  set 
  termout onset pagesize 0set echo offset feedback offset 
  sqlprompt ''spool c:\temp.sqlselect 'set sqlprompt '''||name||' > 
  '';' from v$database;spool off@c:\temp.sqlset pagesize 35set 
  feedback onset termout off
  What 
  this does is to take the name of the database from v$database and create a 
  temporary SQL file, then runs it.  This will set my prompt to 
  
  <FONT color=#0000ff face=Arial 
  size=2> 
  <FONT color=#0000ff face=Arial 
  size=2>INSTANCE_NAME > 
  <FONT color=#0000ff face=Arial 
  size=2> 
  <FONT color=#0000ff face=Arial 
  size=2>where INSTANCE_NAME is the name of the database.
  <FONT color=#0000ff face=Arial 
  size=2> 
  For 
  example, if I log onto DEV then the SQLPROMPT will be
  <FONT color=#0000ff face=Arial 
  size=2> 
  DEV 
  > 
  <FONT color=#0000ff face=Arial 
  size=2> 
  Hope 
  you can use it.
  <FONT color=#0000ff face=Arial 
  size=2> 
  <FONT color=#0000ff face=Arial 
  size=2>Kevin
  <FONT color=#0000ff face=Arial 
  size=2> 
  p.s. 
  ...  Remember that  this only works for the initialization of SQL 
  Plus.  If you do a connect inside of your session then the prompt will 
  not change.
  
    <FONT face=Tahoma 
    size=2>-----Original Message-----From: Ramon Estevez 
    [mailto:com.banilejas@codetel.net.do]Sent: Thursday, October 25, 
    2001 9:35 AMTo: Multiple recipients of list 
    ORACLE-LSubject: Instance Name in Sql Prompt
    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@codetel.net.do
    Dominican Republic
    809-565-3121