Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: Dynamic prompt in SQL*PLUS

RE: Dynamic prompt in SQL*PLUS

From: david hill <david.hill_at_lechateau.ca>
Date: Wed, 25 Feb 2004 12:35:51 -0500
Message-ID: <A722EED83069D611AED200508B8B0D91217480@exchange.LeChateau.ca>






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
-----------------------------------------------------------------



Please see the official ORACLE-L FAQ: http://www.orafaq.com

To unsubscribe send email to: oracle-l-request_at_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
-----------------------------------------------------------------
Received on Wed Feb 25 2004 - 11:33:29 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US