RE: Dynamic prompt in SQL*PLUS

From: Prem Khanna J <jprem_at_kssnet.co.jp>
Date: Tue, 24 Feb 2004 16:59:51 +0900
Message-ID: <005901c3faac$2e740460$dd00a8c0@prem>

Hi Tanel , thanx for letting me know that. I missed the word "dynamic" in Naveen's mail.

BTW,where i do set the variables u said ? SET SQLPROMPT _USER'@'_CONNECT_IDENTIFIER> can i put this is in glogin.sql ?

Regards,
Prem.

>>-----Original Message-----
>>From: Tanel Poder
>>Prem,
>>
>>This doesn't work "dynamicly", e.g. when you issue a connect clause to
>>another user/connect string from inside sqlplus, then the
>>prompt will retain
>>the old values. But these new sqlplus variables I posted, will work
>>dynamicly as well.
>>
>>Tanel.

---

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 Tue Feb 24 2004 - 01:55:19 CST