Thanks
David, Jack it works !!
<SPAN
class=123050920-25102001>
Ramon E.
Estevez
<A
href="">com.banilejas_at_codetel.net.do
Dominican Republic
809-565-3121
<FONT face=Tahoma
size=2>-----Mensaje original-----De: root_at_fatcity.com
[mailto:root_at_fatcity.com]En nombre de David WagonerEnviado
el: Thursday, 25 October, 2001 10:22 AMPara: Multiple
recipients of list ORACLE-LAsunto: RE: Instance Name in Sql
Prompt
<FONT color=blue face=Arial
size=2><SPAN
style="FONT-FAMILY: Arial; FONT-SIZE: 10pt; mso-bidi-font-size: 12.0pt">Add
the following to your login.sql or glogin.sql
file:
<FONT color=blue face=Arial
size=2><SPAN
style="FONT-FAMILY: Arial; FONT-SIZE: 10pt; mso-bidi-font-size: 12.0pt">
<FONT color=blue
face="Courier New" size=2><SPAN
style="COLOR: blue; FONT-FAMILY: 'Courier New'; FONT-SIZE: 10pt">set
serveroutput on<SPAN
style="COLOR: blue; FONT-FAMILY: 'Courier New'; FONT-SIZE: 10pt; mso-color-alt: windowtext">
<FONT color=blue
face="Courier New" size=2><SPAN
style="COLOR: blue; FONT-FAMILY: 'Courier New'; FONT-SIZE: 10pt">set termout
off<SPAN
style="COLOR: blue; FONT-FAMILY: 'Courier New'; FONT-SIZE: 10pt; mso-color-alt: windowtext">
<FONT color=blue
face="Courier New" size=2><SPAN
style="COLOR: blue; FONT-FAMILY: 'Courier New'; FONT-SIZE: 10pt">column
instance new_value prompt_instance<FONT color=blue
face="Courier New" size=2><SPAN
style="COLOR: blue; FONT-FAMILY: 'Courier New'; FONT-SIZE: 10pt; mso-color-alt: windowtext">
<FONT color=blue
face="Courier New" size=2><SPAN
style="COLOR: blue; FONT-FAMILY: 'Courier New'; FONT-SIZE: 10pt">select
substr(instance_name, 1, 10)instance<FONT color=blue
face="Courier New" size=2><SPAN
style="COLOR: blue; FONT-FAMILY: 'Courier New'; FONT-SIZE: 10pt; mso-color-alt: windowtext">
<FONT color=blue
face="Courier New" size=2><SPAN
style="COLOR: blue; FONT-FAMILY: 'Courier New'; FONT-SIZE: 10pt">from
v$instance<SPAN
style="COLOR: blue; FONT-FAMILY: 'Courier New'; FONT-SIZE: 10pt; mso-color-alt: windowtext">
<FONT color=blue
face="Courier New" size=2><SPAN
style="COLOR: blue; FONT-FAMILY: 'Courier New'; FONT-SIZE: 10pt">/<FONT
color=blue face="Courier New" size=2><SPAN
style="COLOR: blue; FONT-FAMILY: 'Courier New'; FONT-SIZE: 10pt; mso-color-alt: windowtext">
<FONT color=blue
face="Courier New" size=2><SPAN
style="COLOR: blue; FONT-FAMILY: 'Courier New'; FONT-SIZE: 10pt">set sqlprompt
"&&prompt_instance> "<FONT color=blue
face="Courier New" size=2><SPAN
style="COLOR: blue; FONT-FAMILY: 'Courier New'; FONT-SIZE: 10pt; mso-color-alt: windowtext">
<FONT color=blue
face="Courier New" size=2><SPAN
style="COLOR: blue; FONT-FAMILY: 'Courier New'; FONT-SIZE: 10pt">set termout
on<SPAN
style="COLOR: blue; FONT-FAMILY: 'Courier New'; FONT-SIZE: 10pt; mso-color-alt: windowtext">
<FONT color=blue face=Arial
size=2><SPAN
style="FONT-FAMILY: Arial; FONT-SIZE: 10pt; mso-bidi-font-size: 12.0pt">
<FONT color=blue face=Arial
size=2><SPAN
style="FONT-FAMILY: Arial; FONT-SIZE: 10pt; mso-bidi-font-size: 12.0pt">
<FONT color=blue face=Arial
size=2><SPAN
style="FONT-FAMILY: Arial; FONT-SIZE: 10pt; mso-bidi-font-size: 12.0pt">HTH,
<FONT color=blue face=Arial
size=2><SPAN
style="FONT-FAMILY: Arial; FONT-SIZE: 10pt; mso-bidi-font-size: 12.0pt">
<FONT color=blue face=Arial
size=2><SPAN
style="FONT-FAMILY: Arial; FONT-SIZE: 10pt; mso-bidi-font-size: 12.0pt">david
<FONT color=blue face=Arial
size=2><SPAN
style="FONT-FAMILY: Arial; FONT-SIZE: 10pt; 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
color=blue face=Arial><SPAN
style="COLOR: blue; FONT-FAMILY: Arial; FONT-WEIGHT: bold">David B.
Wagoner
<SPAN
style="COLOR: blue; FONT-FAMILY: Arial; FONT-SIZE: 10pt; FONT-STYLE: italic; mso-bidi-font-size: 12.0pt">Database
Administrator<SPAN
style="COLOR: blue; FONT-FAMILY: Arial; FONT-SIZE: 10pt; FONT-STYLE: italic; mso-bidi-font-size: 12.0pt; mso-color-alt: windowtext">
<SPAN
style="COLOR: blue; FONT-FAMILY: Arial; FONT-SIZE: 10pt; FONT-WEIGHT: bold; mso-bidi-font-size: 12.0pt">Arsenal
Digital Solutions Worldwide Inc.<FONT color=blue
face=Arial size=2><SPAN
style="COLOR: blue; FONT-FAMILY: Arial; FONT-SIZE: 10pt; FONT-WEIGHT: bold; mso-bidi-font-size: 12.0pt; mso-color-alt: windowtext">
<SPAN
style="COLOR: blue; FONT-FAMILY: Arial; FONT-SIZE: 10pt; mso-bidi-font-size: 12.0pt">4815
Emperor Blvd., Suite 110<SPAN
style="COLOR: blue; FONT-FAMILY: Arial; FONT-SIZE: 10pt; mso-bidi-font-size: 12.0pt; mso-color-alt: windowtext">
<SPAN
style="COLOR: blue; FONT-FAMILY: Arial; FONT-SIZE: 10pt; mso-bidi-font-size: 12.0pt">Durham,
NC 27703<SPAN
style="COLOR: blue; FONT-FAMILY: Arial; FONT-SIZE: 10pt; mso-bidi-font-size: 12.0pt; mso-color-alt: windowtext">
<SPAN
style="COLOR: blue; FONT-FAMILY: Arial; FONT-SIZE: 10pt; mso-bidi-font-size: 12.0pt">Tel.
(919) 941-4645<SPAN
style="COLOR: blue; FONT-FAMILY: Arial; FONT-SIZE: 10pt; mso-bidi-font-size: 12.0pt; mso-color-alt: windowtext">
<SPAN
style="COLOR: blue; FONT-FAMILY: Arial; FONT-SIZE: 10pt; mso-bidi-font-size: 12.0pt">Fax
(919) 474-0735<SPAN
style="COLOR: blue; FONT-FAMILY: Arial; FONT-SIZE: 10pt; mso-bidi-font-size: 12.0pt; mso-color-alt: windowtext">
<SPAN
style="COLOR: blue; FONT-FAMILY: Arial; FONT-SIZE: 10pt; mso-bidi-font-size: 12.0pt">Email
<FONT face="Times New Roman"
size=3><SPAN
style="FONT-FAMILY: 'Times New Roman'; FONT-SIZE: 12pt">mailto:dwagoner_at_arsenaldigital.com<FONT
color=blue face=Arial size=2><SPAN
style="COLOR: blue; FONT-FAMILY: Arial; FONT-SIZE: 10pt; mso-bidi-font-size: 12.0pt; mso-color-alt: windowtext">
<SPAN
style="COLOR: blue; FONT-FAMILY: Arial; FONT-SIZE: 10pt; mso-bidi-font-size: 12.0pt">Web
<FONT face="Times New Roman"
size=3><SPAN
style="FONT-FAMILY: 'Times New Roman'; FONT-SIZE: 12pt">http://www.arsenaldigital.com/<FONT
color=blue face=Arial size=2><SPAN
style="COLOR: blue; FONT-FAMILY: Arial; FONT-SIZE: 10pt; mso-bidi-font-size: 12.0pt; mso-color-alt: windowtext">
<SPAN
style="COLOR: blue; FONT-FAMILY: Arial; FONT-SIZE: 10pt; mso-bidi-font-size: 12.0pt"> <FONT
color=blue face=Arial size=2><SPAN
style="COLOR: blue; FONT-FAMILY: Arial; FONT-SIZE: 10pt; mso-bidi-font-size: 12.0pt; mso-color-alt: windowtext">
<SPAN
style="COLOR: blue; FONT-FAMILY: Arial; FONT-SIZE: 8pt; mso-bidi-font-size: 12.0pt"><SPAN
style="mso-spacerun: yes">
*** NOTICE<SPAN
style="mso-spacerun: yes"> ***<FONT color=blue
face=Arial size=1><SPAN
style="COLOR: blue; FONT-FAMILY: Arial; FONT-SIZE: 8pt; mso-bidi-font-size: 12.0pt; mso-color-alt: windowtext">
<SPAN
style="COLOR: blue; FONT-FAMILY: Arial; FONT-SIZE: 8pt; 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
color=blue face=Arial size=1><SPAN
style="COLOR: blue; FONT-FAMILY: Arial; FONT-SIZE: 8pt; 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-FAMILY: Arial; FONT-SIZE: 10pt; mso-bidi-font-size: 12.0pt">
<FONT color=black face=Tahoma
size=2><SPAN
style="COLOR: black; FONT-FAMILY: Tahoma; FONT-SIZE: 10pt">-----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>
<FONT color=black face=Verdana
size=3>Hi
Friends,<SPAN
style="COLOR: black; mso-color-alt: windowtext">
<FONT color=black
face="Times New Roman" size=3><SPAN
style="COLOR: black; FONT-SIZE: 12pt"> <FONT
color=black><SPAN
style="COLOR: black; mso-color-alt: windowtext">
<FONT color=black face=Verdana
size=3><SPAN
style="COLOR: black; FONT-FAMILY: Verdana; FONT-SIZE: 12pt">Excuse me for this
dumb question, how do I display the instance name in
the<SPAN
style="COLOR: black; mso-color-alt: windowtext">
<FONT color=black face=Verdana
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 color=black
face="Times New Roman" size=3><SPAN
style="COLOR: black; FONT-SIZE: 12pt"> <FONT
color=black><SPAN
style="COLOR: black; mso-color-alt: windowtext">
<FONT color=black face=Verdana
size=3>I
mean something like that.<SPAN
style="COLOR: black; mso-color-alt: windowtext">
<FONT color=black
face="Times New Roman" size=3><SPAN
style="COLOR: black; FONT-SIZE: 12pt"> <FONT
color=black><SPAN
style="COLOR: black; mso-color-alt: windowtext">
<FONT color=black face=Verdana
size=3>DBA1
><SPAN
style="COLOR: black; mso-color-alt: windowtext">
<FONT color=black face=Verdana
size=3>DBA2
><SPAN
style="COLOR: black; mso-color-alt: windowtext">
<FONT color=black face=Verdana
size=3>DB01
><SPAN
style="COLOR: black; mso-color-alt: windowtext">
<FONT color=black
face="Times New Roman" size=3><SPAN
style="COLOR: black; FONT-SIZE: 12pt"> <FONT
color=black><SPAN
style="COLOR: black; mso-color-alt: windowtext">
<FONT color=black face=Verdana
size=3><SPAN
style="COLOR: black; FONT-FAMILY: Verdana; FONT-SIZE: 12pt">Regards,<FONT
color=black><SPAN
style="COLOR: black; mso-color-alt: windowtext">
<FONT color=black
face="Times New Roman" size=3><SPAN
style="COLOR: black; FONT-SIZE: 12pt"> <FONT
color=black><SPAN
style="COLOR: black; mso-color-alt: windowtext">
<FONT color=black face=Verdana
size=3>Ramon
E. Estevez<SPAN
style="COLOR: black; mso-color-alt: windowtext">
<FONT color=black face=Verdana
size=3><A
href="">com.banilejas_at_codetel.net.do<FONT
color=black><SPAN
style="COLOR: black; mso-color-alt: windowtext">
<FONT color=black face=Verdana
size=3><SPAN
style="COLOR: black; FONT-FAMILY: Verdana; FONT-SIZE: 12pt">Dominican
Republic<SPAN
style="COLOR: black; mso-color-alt: windowtext">
<FONT color=black face=Verdana
size=3><SPAN
style="COLOR: black; FONT-FAMILY: Verdana; FONT-SIZE: 12pt">809-565-3121<FONT
color=black><SPAN
style="COLOR: black; mso-color-alt: windowtext">
<FONT color=black
face="Times New Roman" size=3><SPAN
style="COLOR: black; FONT-SIZE: 12pt"> <FONT
color=black><SPAN
style="COLOR: black; mso-color-alt: windowtext">
Received on Thu Oct 25 2001 - 14:16:10 CDT
