RE: SQL*Plus Client on Windows

True. You could however, (for < 10g), incorporate the appropriate parts into scripts named prompt.sql and connect.sql (or use 10g client).  

When connecting from sql prompt SQL > @PROMPT or @CONNECT . connect.sql could call prompt.sql automagically.  

@connect prompts you from username password etc.
 

@prompt is if you are already connected... sets the prompt.
 

Really 10g obsoletes all this so you could install 10g client and all can be set from glogin.sql. Then you can connect from one database to another and your prompt will change automagically even if you are connecting to Oracle 9 databases.  

Joel Patterson
Database Administrator
joel.patterson_at_crowley.com
x72546
904 727-2546

From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Jared Still Sent: Monday, September 10, 2007 1:26 PM To: tanel.poder.003_at_mail.ee
Cc: Michael.Coll-Barth_at_verizonwireless.com; oracle-l Subject: Re: SQL*Plus Client on Windows  

On 9/8/07, Tanel Poder <tanel.poder.003_at_mail.ee> wrote:

        Here's my i.sql which I use both for identifying where I'm logged on before

        doing any changes to database, plus it is called through login.sql. The

        window title change happens on the last line:

There is one small problem with that approach:

If you use 'connect' within sqlplus, and sqlplus is < 10g your title will
not change, and you may become confused as to which system you are really on.

One way around that is to use a wrapper for connect.

Another way is to never use 'connect' from the command line, just exit and restart sqlplus with the new connection.

-- 
Jared Still
Certifiable Oracle DBA and Part Time Perl Evangelist


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