RE: Dynamic prompt in SQL*PLUS

From: Prem Khanna J <jprem_at_kssnet.co.jp>
Date: Tue, 24 Feb 2004 16:31:33 +0900
Message-ID: <004901c3faa8$3a83ed00$dd00a8c0@prem>

Tanel , this works for me on v9.2.0.4.

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

I got this piece of code on this list.

Regards,
Prem.

>>-----Original Message-----
>>Tanel Pîer
>>
>>Hi!
>>In 10g you can use _USER and _CONNECT_IDENTIFIER sqlplus
>>variables, for example:
>>SET SQLPROMPT _USER'@'_CONNECT_IDENTIFIER>
>>Before 10g you can't have dynamic prompt inside sqlplus.
>>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:26:56 CST