Return-Path: Delivered-To: 2-oracle-l@orafaq.com Received: (qmail 15566 invoked from network); 10 Sep 2007 14:46:57 -0500 Received: from freelists-180.iquest.net (HELO turing.freelists.org) (206.53.239.180) by 69.64.49.119 with SMTP; 10 Sep 2007 14:46:54 -0500 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 038CF73D862; Mon, 10 Sep 2007 15:08:11 -0400 (EDT) Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing.freelists.org [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 27792-04-2; Mon, 10 Sep 2007 15:08:10 -0400 (EDT) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 23FAB73D614; Mon, 10 Sep 2007 15:08:10 -0400 (EDT) Received: with ECARTIS (v1.0.0; list oracle-l); Mon, 10 Sep 2007 14:23:38 -0400 (EDT) Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id C4EC773C76C for ; Mon, 10 Sep 2007 14:23:38 -0400 (EDT) Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing.freelists.org [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 18629-03 for ; Mon, 10 Sep 2007 14:23:38 -0400 (EDT) Received: from Jaxsmtp01.crowley.com (outbound.crowley.com [12.24.152.45]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 7DE4C73BAEF for ; Mon, 10 Sep 2007 14:23:12 -0400 (EDT) Received: from JAX-MBH-01.crowley.com ([10.104.0.85]) by Jaxsmtp01.crowley.com with Microsoft SMTPSVC(5.0.2195.6713); Mon, 10 Sep 2007 14:27:33 -0400 X-MimeOLE: Produced By Microsoft Exchange V6.5 Content-class: urn:content-classes:message MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----_=_NextPart_001_01C7F3D8.412ED458" Subject: RE: SQL*Plus Client on Windows Date: Mon, 10 Sep 2007 14:27:32 -0400 Message-ID: <02C2FA1C9961934BB6D16DE35707B27B03575AE9@jax-mbh-01.jax.crowley.com> In-Reply-To: X-MS-Has-Attach: X-MS-TNEF-Correlator: Thread-Topic: SQL*Plus Client on Windows From: To: , Cc: , X-OriginalArrivalTime: 10 Sep 2007 18:27:33.0936 (UTC) FILETIME=[416AEB00:01C7F3D8] X-archive-position: 1410 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-to: oracle-l-bounce@freelists.org X-original-sender: Joel.Patterson@crowley.com Precedence: normal Reply-to: Joel.Patterson@crowley.com List-help: List-unsubscribe: List-software: Ecartis version 1.0.0 List-Id: oracle-l X-List-ID: oracle-l List-subscribe: List-owner: List-post: List-archive: X-list: oracle-l X-Virus-Scanned: Debian amavisd-new at localhost.localdomain ------_=_NextPart_001_01C7F3D8.412ED458 Content-Type: text/plain; charset="US-ASCII" Content-Transfer-Encoding: quoted-printable True. You could however, (for < 10g), incorporate the appropriate parts into scripts named prompt.sql and connect.sql (or use 10g client). =20 When connecting from sql prompt SQL > @PROMPT or @CONNECT . connect.sql could call prompt.sql automagically. =20 @connect prompts you from username password etc. =20 @prompt is if you are already connected... sets the prompt. =20 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. =20 Joel Patterson=20 Database Administrator=20 joel.patterson@crowley.com=20 x72546=20 904 727-2546=20 ________________________________ From: oracle-l-bounce@freelists.org [mailto:oracle-l-bounce@freelists.org] On Behalf Of Jared Still Sent: Monday, September 10, 2007 1:26 PM To: tanel.poder.003@mail.ee Cc: Michael.Coll-Barth@verizonwireless.com; oracle-l Subject: Re: SQL*Plus Client on Windows =20 On 9/8/07, Tanel Poder 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=20 not change, and you may become confused as to which system you are really on.=20 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. --=20 Jared Still Certifiable Oracle DBA and Part Time Perl Evangelist ------_=_NextPart_001_01C7F3D8.412ED458 Content-Type: text/html; charset="US-ASCII" Content-Transfer-Encoding: quoted-printable

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@crowley.com
x72546
904  727-2546

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

 

On 9/8/07, Tanel = Poder <tanel.poder.003@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

------_=_NextPart_001_01C7F3D8.412ED458-- -- http://www.freelists.org/webpage/oracle-l