RE: SQL*Plus Client on Windows

Not an answer to your query but just another approach. Wouldn't login.sql do? This runs every time you make a connection and you can set the Sqlprompt to the dbstring here.

thanks!
amar kumar Padhi
www.amar-padhi.com
Pushed from PDA

-----Original Message-----

From: Michael.Coll-Barth_at_VerizonWireless.com To: "oracle-l" <oracle-l_at_freelists.org>
Sent: 9/09/07 5:49 AM
Subject: SQL*Plus Client on Windows

Hi all!  

This is in reference to the 10g ( 10.2.0.1.0 ) SQL*Plus client for Windows ( XP for me ).  

Does anyone know if there is a way to change the bar at the top of the SQL*Plus client window so it will display the _CONNECT_IDENTIFIER and _USER variables. This is the same bar at the top of the client's window that has the Minimize, Maximize and Close boxes in the upper right of the window. If its a hack, so be it...

I am constantly connecting to different instances and sometimes have to type 'DEFINE' to remember where I am.  

TIA,
Michael          

The information contained in this message and any attachment may be proprietary, confidential, and privileged or subject to the work product doctrine and thus protected from disclosure. If the reader of this message is not the intended recipient, or an employee or agent responsible for delivering this message to the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited. If you have received this communication in error, please notify me immediately by replying to this message and deleting it and all copies and backups thereof. Thank you.

--

http://www.freelists.org/webpage/oracle-l

--

http://www.freelists.org/webpage/oracle-l Received on Sat Sep 08 2007 - 17:18:11 CDT