RE: SQL*Plus Client on Windows
- From: Tanel Poder <tanel.poder.003@xxxxxxx>
- To: "'Jared Still'" <jkstill@xxxxxxxxx>
- Date: Tue, 11 Sep 2007 09:29:44 +0800
Yeah, that's why I use this i.sql script I posted earlier - it reports the
instance details from v$instance directly.
Before changing anything in a DB, I run that script to verify where I'm
logged on, regardless what my sql prompt or window title says..
--
Regards,
Tanel Poder
http://blog.tanelpoder.com <http://blog.tanelpoder.com/>
_____
From: Jared Still [mailto:jkstill@xxxxxxxxx]
Sent: Tuesday, September 11, 2007 01:26
To: tanel.poder.003@xxxxxxx
Cc: Michael.Coll-Barth@xxxxxxxxxxxxxxxxxxx; oracle-l
Subject: Re: SQL*Plus Client on Windows
On 9/8/07, Tanel Poder <tanel.poder.003@xxxxxxx> 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.
Other related posts:
