RE: SQL*Plus Client on Windows

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_at_gmail.com] Sent: Tuesday, September 11, 2007 01:26
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.

--

http://www.freelists.org/webpage/oracle-l Received on Mon Sep 10 2007 - 20:29:44 CDT