RE: Instance Name in Sql Prompt

From: David Wagoner <dwagoner_at_arsenaldigital.com>
Date: Thu, 25 Oct 2001 07:37:40 -0700
Message-ID: <F001.003B444A.20011025072131@fatcity.com>

<span

style='font-size:10.0pt;mso-bidi-font-size:12.0pt;font-family:Arial'>Add the following to your login.sql or glogin.sql file:

<span

style='font-size:10.0pt;mso-bidi-font-size:12.0pt;font-family:Arial'> 

<font

size=2 color=blue face="Courier New"><span style='font-size:10.0pt;font-family: "Courier New";color:blue'>set serveroutput on<font size=2 color=blue face="Courier New"><span style='font-size:10.0pt;font-family:"Courier New"; color:blue;mso-color-alt:windowtext'>

<font

size=2 color=blue face="Courier New"><span style='font-size:10.0pt;font-family: "Courier New";color:blue'>set termout off<font size=2 color=blue face="Courier New"><span style='font-size:10.0pt;font-family:"Courier New"; color:blue;mso-color-alt:windowtext'>

<font

size=2 color=blue face="Courier New"><span style='font-size:10.0pt;font-family: "Courier New";color:blue'>column instance new_value prompt_instance<font size=2 color=blue face="Courier New"><span style='font-size:10.0pt;font-family: "Courier New";color:blue;mso-color-alt:windowtext'>

<font

size=2 color=blue face="Courier New"><span style='font-size:10.0pt;font-family: "Courier New";color:blue'>select substr(instance_name, 1, 10)instance<font size=2 color=blue face="Courier New"><span style='font-size:10.0pt;font-family: "Courier New";color:blue;mso-color-alt:windowtext'>

<font

size=2 color=blue face="Courier New"><span style='font-size:10.0pt;font-family: "Courier New";color:blue'>from v$instance<font size=2 color=blue face="Courier New"><span style='font-size:10.0pt;font-family:"Courier New"; color:blue;mso-color-alt:windowtext'>

<font

size=2 color=blue face="Courier New"><span style='font-size:10.0pt;font-family: "Courier New";color:blue'>/<font size=2 color=blue face="Courier New"><span style='font-size:10.0pt;font-family:"Courier New"; color:blue;mso-color-alt:windowtext'>

<font

size=2 color=blue face="Courier New"><span style='font-size:10.0pt;font-family: "Courier New";color:blue'>set sqlprompt "&&prompt_instance> "<span
style='font-size:10.0pt;font-family:"Courier New";color:blue;mso-color-alt: windowtext'>

<font

size=2 color=blue face="Courier New"><span style='font-size:10.0pt;font-family: "Courier New";color:blue'>set termout on<font size=2 color=blue face="Courier New"><span style='font-size:10.0pt;font-family:"Courier New"; color:blue;mso-color-alt:windowtext'>

<span

style='font-size:10.0pt;mso-bidi-font-size:12.0pt;font-family:Arial'> 

<span

style='font-size:10.0pt;mso-bidi-font-size:12.0pt;font-family:Arial'> 

<span

style='font-size:10.0pt;mso-bidi-font-size:12.0pt;font-family:Arial'>HTH,

<span

style='font-size:10.0pt;mso-bidi-font-size:12.0pt;font-family:Arial'> 

<span

style='font-size:10.0pt;mso-bidi-font-size:12.0pt;font-family:Arial'>david

<span

style='font-size:10.0pt;mso-bidi-font-size:12.0pt;font-family:Arial'> 

<!---size:10.0pt;mso-bidi-font-size:

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

<span

style='font-size:10.0pt;mso-bidi-font-size:12.0pt;font-family:Arial;color:blue; font-style:italic'>Database Administrator<font size=2 color=blue face=Arial><span style='font-size:10.0pt;mso-bidi-font-size:12.0pt; font-family:Arial;color:blue;mso-color-alt:windowtext;font-style:italic'>

<span

style='font-size:10.0pt;mso-bidi-font-size:12.0pt;font-family:Arial;color:blue; font-weight:bold'>Arsenal Digital Solutions Worldwide Inc.<font size=2 color=blue face=Arial><span style='font-size:10.0pt;mso-bidi-font-size: 12.0pt;font-family:Arial;color:blue;mso-color-alt:windowtext;font-weight:bold'>

<span style='font-size:

10.0pt;mso-bidi-font-size:12.0pt;font-family:Arial;color:blue'>4815 Emperor Blvd., Suite 110<span
style='font-size:10.0pt;mso-bidi-font-size:12.0pt;font-family:Arial;color:blue; mso-color-alt:windowtext'>

<span style='font-size:

10.0pt;mso-bidi-font-size:12.0pt;font-family:Arial;color:blue'>Durham, NC 27703<font size=2 color=blue face=Arial><span style='font-size:10.0pt;mso-bidi-font-size: 12.0pt;font-family:Arial;color:blue;mso-color-alt:windowtext'>

<span style='font-size:

10.0pt;mso-bidi-font-size:12.0pt;font-family:Arial;color:blue'>Tel. (919) 941-4645<span
style='font-size:10.0pt;mso-bidi-font-size:12.0pt;font-family:Arial;color:blue; mso-color-alt:windowtext'>

<span style='font-size:

10.0pt;mso-bidi-font-size:12.0pt;font-family:Arial;color:blue'>Fax (919) 474-0735<span
style='font-size:10.0pt;mso-bidi-font-size:12.0pt;font-family:Arial;color:blue; mso-color-alt:windowtext'>

<span style='font-size:

10.0pt;mso-bidi-font-size:12.0pt;font-family:Arial;color:blue'>Email <a href=""><span
style='font-size:12.0pt;font-family:"Times New Roman"'>mailto:dwagoner_at_arsenaldigital.com<font size=2 color=blue face=Arial><span style='font-size:10.0pt;mso-bidi-font-size: 12.0pt;font-family:Arial;color:blue;mso-color-alt:windowtext'>

<span style='font-size:

10.0pt;mso-bidi-font-size:12.0pt;font-family:Arial;color:blue'>Web <a href=""><span
style='font-size:12.0pt;font-family:"Times New Roman"'>http://www.arsenaldigital.com/<font size=2 color=blue face=Arial><span style='font-size:10.0pt;mso-bidi-font-size: 12.0pt;font-family:Arial;color:blue;mso-color-alt:windowtext'>

<span style='font-size:

10.0pt;mso-bidi-font-size:12.0pt;font-family:Arial;color:blue'> <font size=2 color=blue face=Arial><span style='font-size:10.0pt;mso-bidi-font-size: 12.0pt;font-family:Arial;color:blue;mso-color-alt:windowtext'>

<span style='font-size:

8.0pt;mso-bidi-font-size:12.0pt;font-family:Arial;color:blue'><span style="mso-spacerun:

yes">                                                                                                         

***  NOTICE<span
style="mso-spacerun: yes">  ***<font size=1 color=blue face=Arial><span style='font-size:8.0pt;mso-bidi-font-size:12.0pt; font-family:Arial;color:blue;mso-color-alt:windowtext'>

<span style='font-size:

8.0pt;mso-bidi-font-size:12.0pt;font-family:Arial;color:blue'>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.  Thank you.<font
size=1 color=blue face=Arial><span style='font-size:8.0pt;mso-bidi-font-size: 12.0pt;font-family:Arial;color:blue;mso-color-alt:windowtext'>

<!---size:10.0pt;mso-bidi-font-size:

12.0pt;font-family:Arial'><span
class=EmailStyle18><span style='font-size: 10.0pt;mso-bidi-font-size:12.0pt;font-family:Arial'> 

<font size=2 color=black

face=Tahoma>-----Original
Message-----
From: Ramon Estevez
[mailto:com.banilejas_at_codetel.net.do]
Sent: Thursday, October 25, 2001
10:35 AM
To: Multiple recipients of list
ORACLE-L
Subject: Instance Name in Sql
Prompt

<span

style='font-size:12.0pt'> 

<font size=3 color=black

face=Verdana>Hi
Friends,<span style='color:black;mso-color-alt: windowtext'>

<font size=3 color=black

face="Times New Roman"> <font
color=black>

<font size=3 color=black

face=Verdana>Excuse
me for this dumb question,  how do I display the instance name in the<font color=black>

<font size=3 color=black

face=Verdana>sql
prompt.  Have 3 DB and would like to know to which one I am connected.<font color=black>

<font size=3 color=black

face="Times New Roman"> <font
color=black>

<font size=3 color=black

face=Verdana>I
mean something like that.<span
style='color:black;mso-color-alt:windowtext'>

<font size=3 color=black

face="Times New Roman"> <font
color=black>

<font size=3 color=black

face=Verdana>DBA1
><span style='color:black;mso-color-alt: windowtext'>

<font size=3 color=black

face=Verdana>DBA2
><span style='color:black;mso-color-alt: windowtext'>

<font size=3 color=black

face=Verdana>DB01
><span style='color:black;mso-color-alt: windowtext'>

<font size=3 color=black

face="Times New Roman"> <font
color=black>

<font size=3 color=black

face=Verdana>Regards,<font
color=black>

<font size=3 color=black

face="Times New Roman"> <font
color=black>

<font size=3 color=black

face=Verdana>Ramon
E. Estevez<span style='color:black;mso-color-alt: windowtext'>

<font size=3 color=black

face=Verdana><a
href="">com.banilejas_at_codetel.net.do<font color=black>

<font size=3 color=black

face=Verdana>Dominican
Republic<span style='color:black;mso-color-alt: windowtext'>

<font size=3 color=black

face=Verdana>809-565-3121<font
color=black>

<font size=3 color=black

face="Times New Roman"> <font
color=black> Received on Thu Oct 25 2001 - 09:37:40 CDT