RE: Dynamic prompt in SQL*PLUS

From: Prem Khanna J <jprem_at_kssnet.co.jp>
Date: Tue, 24 Feb 2004 16:28:16 +0900
Message-ID: <004501c3faa7$c4f6d8e0$dd00a8c0@prem>

Hi Naven,

Just paste the lines below in ur ORACLE_HOME/sqlplus/admin/glogin.sql

--------------8<--------------8<--------------8<--------------8<--------
------8<--------------8<----

COLUMN gname new_value gname noprint
SET feed OFF verify OFF
SELECT UPPER(USER)||'@&_CONNECT_IDENTIFIER'||' SQL>' gname FROM dual; SET sqlprompt '&gname> ' feed ON verify ON
--------------8<--------------8<--------------8<--------------8<--------
------8<--------------8<----

Hope this is what u need .

Regards,
Prem.

---

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:23:39 CST