RE: Dynamic prompt in SQL*PLUS

From: Prem Khanna J <jprem_at_kssnet.co.jp>
Date: Tue, 24 Feb 2004 17:27:41 +0900
Message-ID: <006401c3fab0$12c84a10$dd00a8c0@prem>

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_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 - 02:23:04 CST