RE: Instance Name in Sql Prompt

From: Kevin Lange <kgel_at_ppoone.com>
Date: Thu, 25 Oct 2001 08:06:36 -0700
Message-ID: <F001.003B45F4.20011025081554@fatcity.com>

<FONT face=Arial color=#0000ff
size=2>David;
 
I never knew of the NEW_VALUE option on the COLUMN command.  

<FONT face=Arial color=#0000ff
size=2> 
I
always wrote the data out to a temp query and then ran it.   Thanks a lot.  I have replaced my login script and it works fine.

<FONT face=Tahoma

  size=2>-----Original Message-----From: David Wagoner   [mailto:dwagoner_at_arsenaldigital.com]Sent: Thursday, October 25,   2001 10:22 AMTo: Multiple recipients of list   ORACLE-LSubject: RE: Instance Name in Sql   Prompt   

<FONT face=Arial color=blue

  size=2><SPAN
  style="FONT-SIZE: 10pt; FONT-FAMILY: Arial; mso-bidi-font-size: 12.0pt">Add   the following to your login.sql or glogin.sql   file:
<FONT face=Arial color=blue

  size=2><SPAN
  style="FONT-SIZE: 10pt; FONT-FAMILY: Arial; mso-bidi-font-size: 12.0pt"> 
<FONT

  face="Courier New" color=blue size=2><SPAN   style="FONT-SIZE: 10pt; COLOR: blue; FONT-FAMILY: 'Courier New'">set   serveroutput on<SPAN
  style="FONT-SIZE: 10pt; COLOR: blue; FONT-FAMILY: 'Courier New'; mso-color-alt: windowtext">
<FONT

  face="Courier New" color=blue size=2><SPAN   style="FONT-SIZE: 10pt; COLOR: blue; FONT-FAMILY: 'Courier New'">set termout   off<SPAN
  style="FONT-SIZE: 10pt; COLOR: blue; FONT-FAMILY: 'Courier New'; mso-color-alt: windowtext">
<FONT

  face="Courier New" color=blue size=2><SPAN   style="FONT-SIZE: 10pt; COLOR: blue; FONT-FAMILY: 'Courier New'">column   instance new_value prompt_instance<FONT face="Courier New"   color=blue size=2><SPAN
  style="FONT-SIZE: 10pt; COLOR: blue; FONT-FAMILY: 'Courier New'; mso-color-alt: windowtext">
<FONT

  face="Courier New" color=blue size=2><SPAN   style="FONT-SIZE: 10pt; COLOR: blue; FONT-FAMILY: 'Courier New'">select   substr(instance_name, 1, 10)instance<FONT face="Courier New"   color=blue size=2><SPAN
  style="FONT-SIZE: 10pt; COLOR: blue; FONT-FAMILY: 'Courier New'; mso-color-alt: windowtext">
<FONT

  face="Courier New" color=blue size=2><SPAN   style="FONT-SIZE: 10pt; COLOR: blue; FONT-FAMILY: 'Courier New'">from   v$instance<SPAN
  style="FONT-SIZE: 10pt; COLOR: blue; FONT-FAMILY: 'Courier New'; mso-color-alt: windowtext">
<FONT

  face="Courier New" color=blue size=2><SPAN   style="FONT-SIZE: 10pt; COLOR: blue; FONT-FAMILY: 'Courier New'">/<FONT   face="Courier New" color=blue size=2><SPAN   style="FONT-SIZE: 10pt; COLOR: blue; FONT-FAMILY: 'Courier New'; mso-color-alt: windowtext">
<FONT

  face="Courier New" color=blue size=2><SPAN   style="FONT-SIZE: 10pt; COLOR: blue; FONT-FAMILY: 'Courier New'">set sqlprompt   "&&prompt_instance> "<FONT face="Courier New"   color=blue size=2><SPAN
  style="FONT-SIZE: 10pt; COLOR: blue; FONT-FAMILY: 'Courier New'; mso-color-alt: windowtext">
<FONT

  face="Courier New" color=blue size=2><SPAN   style="FONT-SIZE: 10pt; COLOR: blue; FONT-FAMILY: 'Courier New'">set termout   on<SPAN
  style="FONT-SIZE: 10pt; COLOR: blue; FONT-FAMILY: 'Courier New'; mso-color-alt: windowtext">
<FONT face=Arial color=blue

  size=2><SPAN
  style="FONT-SIZE: 10pt; FONT-FAMILY: Arial; mso-bidi-font-size: 12.0pt"> 
<FONT face=Arial color=blue

  size=2><SPAN
  style="FONT-SIZE: 10pt; FONT-FAMILY: Arial; mso-bidi-font-size: 12.0pt"> 
<FONT face=Arial color=blue

  size=2><SPAN
  style="FONT-SIZE: 10pt; FONT-FAMILY: Arial; mso-bidi-font-size: 12.0pt">HTH,
<FONT face=Arial color=blue

  size=2><SPAN
  style="FONT-SIZE: 10pt; FONT-FAMILY: Arial; mso-bidi-font-size: 12.0pt"> 
<FONT face=Arial color=blue

  size=2><SPAN
  style="FONT-SIZE: 10pt; FONT-FAMILY: Arial; mso-bidi-font-size: 12.0pt">david
<FONT face=Arial color=blue

  size=2><SPAN
  style="FONT-SIZE: 10pt; FONT-FAMILY: Arial; mso-bidi-font-size: 12.0pt"> 
<!---size:10.0pt;mso-bidi-font-size:

12.0pt;font-family:Arial'><span
style="mso-spacerun: yes"> AUTOTEXTLIST \s "E-mail Signature" <FONT
  face=Arial color=blue><SPAN
  style="FONT-WEIGHT: bold; COLOR: blue; FONT-FAMILY: Arial">David B.   Wagoner
<SPAN

  style="FONT-SIZE: 10pt; COLOR: blue; FONT-STYLE: italic; FONT-FAMILY: Arial; mso-bidi-font-size: 12.0pt">Database   Administrator<SPAN
  style="FONT-SIZE: 10pt; COLOR: blue; FONT-STYLE: italic; FONT-FAMILY: Arial; mso-bidi-font-size: 12.0pt; mso-color-alt: windowtext">
<SPAN

  style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; COLOR: blue; FONT-FAMILY: Arial; mso-bidi-font-size: 12.0pt">Arsenal   Digital Solutions Worldwide Inc.<FONT face=Arial   color=blue size=2><SPAN
  style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; COLOR: blue; FONT-FAMILY: Arial; mso-bidi-font-size: 12.0pt; mso-color-alt: windowtext">
<SPAN

  style="FONT-SIZE: 10pt; COLOR: blue; FONT-FAMILY: Arial; mso-bidi-font-size: 12.0pt">4815   Emperor Blvd., Suite 110<SPAN
  style="FONT-SIZE: 10pt; COLOR: blue; FONT-FAMILY: Arial; mso-bidi-font-size: 12.0pt; mso-color-alt: windowtext">
<SPAN

  style="FONT-SIZE: 10pt; COLOR: blue; FONT-FAMILY: Arial; mso-bidi-font-size: 12.0pt">Durham,   NC 27703<SPAN
  style="FONT-SIZE: 10pt; COLOR: blue; FONT-FAMILY: Arial; mso-bidi-font-size: 12.0pt; mso-color-alt: windowtext">
<SPAN

  style="FONT-SIZE: 10pt; COLOR: blue; FONT-FAMILY: Arial; mso-bidi-font-size: 12.0pt">Tel.   (919) 941-4645<SPAN
  style="FONT-SIZE: 10pt; COLOR: blue; FONT-FAMILY: Arial; mso-bidi-font-size: 12.0pt; mso-color-alt: windowtext">
<SPAN

  style="FONT-SIZE: 10pt; COLOR: blue; FONT-FAMILY: Arial; mso-bidi-font-size: 12.0pt">Fax   (919) 474-0735<SPAN
  style="FONT-SIZE: 10pt; COLOR: blue; FONT-FAMILY: Arial; mso-bidi-font-size: 12.0pt; mso-color-alt: windowtext">
<SPAN

  style="FONT-SIZE: 10pt; COLOR: blue; FONT-FAMILY: Arial; mso-bidi-font-size: 12.0pt">Email
<FONT face="Times New Roman"

  size=3><SPAN
  style="FONT-SIZE: 12pt; FONT-FAMILY: 'Times New Roman'">mailto:dwagoner_at_arsenaldigital.com<FONT   face=Arial color=blue size=2><SPAN
  style="FONT-SIZE: 10pt; COLOR: blue; FONT-FAMILY: Arial; mso-bidi-font-size: 12.0pt; mso-color-alt: windowtext">
<SPAN

  style="FONT-SIZE: 10pt; COLOR: blue; FONT-FAMILY: Arial; mso-bidi-font-size: 12.0pt">Web
<FONT face="Times New Roman"

  size=3><SPAN
  style="FONT-SIZE: 12pt; FONT-FAMILY: 'Times New Roman'">http://www.arsenaldigital.com/<FONT   face=Arial color=blue size=2><SPAN
  style="FONT-SIZE: 10pt; COLOR: blue; FONT-FAMILY: Arial; mso-bidi-font-size: 12.0pt; mso-color-alt: windowtext">
<SPAN

  style="FONT-SIZE: 10pt; COLOR: blue; FONT-FAMILY: Arial; mso-bidi-font-size: 12.0pt"> <FONT   face=Arial color=blue size=2><SPAN
  style="FONT-SIZE: 10pt; COLOR: blue; FONT-FAMILY: Arial; mso-bidi-font-size: 12.0pt; mso-color-alt: windowtext">
<SPAN

  style="FONT-SIZE: 8pt; COLOR: blue; FONT-FAMILY: Arial; mso-bidi-font-size: 12.0pt"><SPAN

  style="mso-spacerun: yes">                                                                                                          

  ***  NOTICE<SPAN

  style="mso-spacerun: yes">  ***<FONT face=Arial 
  color=blue size=1><SPAN 
  style="FONT-SIZE: 8pt; COLOR: blue; FONT-FAMILY: Arial; mso-bidi-font-size: 12.0pt; mso-color-alt: windowtext">

<SPAN

  style="FONT-SIZE: 8pt; COLOR: blue; FONT-FAMILY: Arial; mso-bidi-font-size: 12.0pt">This   e-mail message is confidential, intended only for the named recipient(s) above   and may contain information that is privileged, work product or exempt from   disclosure under applicable law. 
  If you have received this message in error, or are not the named   recipient(s), please immediately notify the sender at (919) 941-4645 and   delete this e-mail message from your computer.<SPAN   style="mso-spacerun: yes">  Thank you.<FONT   face=Arial color=blue size=1><SPAN
  style="FONT-SIZE: 8pt; COLOR: blue; FONT-FAMILY: Arial; mso-bidi-font-size: 12.0pt; mso-color-alt: windowtext">
<!---size:10.0pt;mso-bidi-font-size:

12.0pt;font-family:Arial'><SPAN
  class=EmailStyle18><SPAN
  style="FONT-SIZE: 10pt; FONT-FAMILY: Arial; mso-bidi-font-size: 12.0pt"> 
<FONT face=Tahoma color=black

  size=2><SPAN
  style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: Tahoma">-----Original   Message-----From: Ramon
  Estevez [mailto:com.banilejas_at_codetel.net.do]<SPAN   style="FONT-WEIGHT: bold">Sent: Thursday, October 25, 2001 10:35   AMTo: Multiple recipients of
  list ORACLE-LSubject:
  Instance Name in Sql Prompt
<FONT face="Times New Roman"

  size=3><SPAN
  style="FONT-SIZE: 12pt"> 
<FONT face=Verdana color=black

  size=3>Hi
  Friends,<SPAN
  style="COLOR: black; mso-color-alt: windowtext">
<FONT face="Times New Roman"

  color=black size=3><SPAN 
  style="FONT-SIZE: 12pt; COLOR: black"> <FONT 
  color=black><SPAN 
  style="COLOR: black; mso-color-alt: windowtext">

<FONT face=Verdana color=black

  size=3><SPAN
  style="FONT-SIZE: 12pt; COLOR: black; FONT-FAMILY: Verdana">Excuse me for this   dumb question,  how do I display the instance name in   the<SPAN
  style="COLOR: black; mso-color-alt: windowtext">
<FONT face=Verdana color=black

  size=3>sql
  prompt.  Have 3 DB and would like to know to which one I am   connected.<SPAN
  style="COLOR: black; mso-color-alt: windowtext">
<FONT face="Times New Roman"

  color=black size=3><SPAN 
  style="FONT-SIZE: 12pt; COLOR: black"> <FONT 
  color=black><SPAN 
  style="COLOR: black; mso-color-alt: windowtext">

<FONT face=Verdana color=black

  size=3>I
  mean something like that.<SPAN
  style="COLOR: black; mso-color-alt: windowtext">
<FONT face="Times New Roman"

  color=black size=3><SPAN 
  style="FONT-SIZE: 12pt; COLOR: black"> <FONT 
  color=black><SPAN 
  style="COLOR: black; mso-color-alt: windowtext">

<FONT face=Verdana color=black

  size=3>DBA1
  ><SPAN
  style="COLOR: black; mso-color-alt: windowtext">
<FONT face=Verdana color=black

  size=3>DBA2
  ><SPAN
  style="COLOR: black; mso-color-alt: windowtext">
<FONT face=Verdana color=black

  size=3>DB01
  ><SPAN
  style="COLOR: black; mso-color-alt: windowtext">
<FONT face="Times New Roman"

  color=black size=3><SPAN 
  style="FONT-SIZE: 12pt; COLOR: black"> <FONT 
  color=black><SPAN 
  style="COLOR: black; mso-color-alt: windowtext">

<FONT face=Verdana color=black

  size=3><SPAN

  style="FONT-SIZE: 12pt; COLOR: black; FONT-FAMILY: Verdana">Regards,<FONT 
  color=black><SPAN 
  style="COLOR: black; mso-color-alt: windowtext">

<FONT face="Times New Roman"

  color=black size=3><SPAN 
  style="FONT-SIZE: 12pt; COLOR: black"> <FONT 
  color=black><SPAN 
  style="COLOR: black; mso-color-alt: windowtext">

<FONT face=Verdana color=black

  size=3>Ramon
  E. Estevez<SPAN
  style="COLOR: black; mso-color-alt: windowtext">
<FONT face=Verdana color=black

  size=3><A
  href="">com.banilejas_at_codetel.net.do<FONT   color=black><SPAN
  style="COLOR: black; mso-color-alt: windowtext">
<FONT face=Verdana color=black

  size=3><SPAN
  style="FONT-SIZE: 12pt; COLOR: black; FONT-FAMILY: Verdana">Dominican   Republic<SPAN
  style="COLOR: black; mso-color-alt: windowtext">
<FONT face=Verdana color=black

  size=3><SPAN

  style="FONT-SIZE: 12pt; COLOR: black; FONT-FAMILY: Verdana">809-565-3121<FONT 
  color=black><SPAN 
  style="COLOR: black; mso-color-alt: windowtext">

<FONT face="Times New Roman"

  color=black size=3><SPAN 
  style="FONT-SIZE: 12pt; COLOR: black"> <FONT 
  color=black><SPAN 
  style="COLOR: black; mso-color-alt: windowtext">

Received on Thu Oct 25 2001 - 10:06:36 CDT