RE: Dynamic prompt in SQL*PLUS

From oracle-l-bounce@freelists.org Wed Feb 25 11:33:29 2004 Return-Path: Received: from air189.startdedicated.com (root@localhost) by orafaq.com (8.11.6/8.11.6) with ESMTP id i1PHXTZ15864 for ; Wed, 25 Feb 2004 11:33:29 -0600 X-ClientAddr: 206.53.239.180 Received: from turing.freelists.org (freelists-180.iquest.net [206.53.239.180]) by air189.startdedicated.com (8.11.6/8.11.6) with ESMTP id i1PHXTo15858 for ; Wed, 25 Feb 2004 11:33:29 -0600 Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 309C339559D; Wed, 25 Feb 2004 12:34:28 -0500 (EST) Received: with ECARTIS (v1.0.0; list oracle-l); Wed, 25 Feb 2004 12:33:23 -0500 (EST) X-Original-To: oracle-l@freelists.org Delivered-To: oracle-l@freelists.org Received: from exchange.lechateau.ca (mail.lechateau.ca [216.208.134.101]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id B4A2D395466 for ; Wed, 25 Feb 2004 12:33:19 -0500 (EST) Received: by exchange.LeChateau.ca with Internet Mail Service (5.5.2653.19) id ; Wed, 25 Feb 2004 12:35:52 -0500 Message-ID: From: david hill To: "'oracle-l@freelists.org'" Subject: RE: Dynamic prompt in SQL*PLUS Date: Wed, 25 Feb 2004 12:35:51 -0500 MIME-Version: 1.0 X-Mailer: Internet Mail Service (5.5.2653.19) Content-Type: multipart/alternative; boundary="----_=_NextPart_001_01C3FBC5.D050EF40" X-archive-position: 1931 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: david.hill@lechateau.ca Precedence: normal Reply-To: oracle-l@freelists.org X-list: oracle-l ------_=_NextPart_001_01C3FBC5.D050EF40 Content-Type: text/html Content-Transfer-Encoding: quoted-printable RE: Dynamic prompt in SQL*PLUS

Does anyone know of a way to have username/DB = displayed in the title bar(or some other useful place) for iSQL*Plus? =
Since there is no prompt.

Thanks
David Hill
DBA

-----Original Message-----
From: Prem Khanna J [mailto:jprem@kssnet.co.jp] =
Sent: Tuesday, February 24, 2004 3:28 AM
To: oracle-l@freelists.org
Cc: tanel.poder.003@mail.ee
Subject: RE: Dynamic prompt in SQL*PLUS

Thanx again Tanel .

Regards,
Prem.

>>-----Original Message-----
>>From: Tanel Poder
>>Sent: Tuesday, February 24, 2004 5:16 = PM
>>Yes, you can put it into glogin sql.
>>You don't have to set the variables = yourself, sqlplus will
>>populate these
>>itself upon any change to username or = connect string. Also,
>>you could use
>>another variable _DATE for having current = time information in
>>your prompt
>>(it didn't work in my 10g beta on = windows).
>>
>>Tanel.

---------------------------------------------------------------= -
Please see the official ORACLE-L FAQ: http://www.orafaq.com
---------------------------------------------------------------= -
To unsubscribe send email to: = oracle-l-request@freelists.org
put 'unsubscribe' in the subject line.
--
Archives are at http://www.freelists.org/archives/oracle-l/=
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
---------------------------------------------------------------= --