Try this one. set serveroutput on size 1000000
set trimspool on set long 5000 set linesize 100 set pagesize 9999 column plan_plus_exp format a80 column global_name new_value gname set termout off select lower(user) || '@' || decode(global_name, 'ORACLE8.WORLD', '8.0', 'ORA8I.WORLD', '8i', global_name ) global_name from global_name; set sqlprompt '&gname> ' set termout on -- On Thu, 25 Oct 2001 06:35:21 Ramon Estevez wrote: >Hi Friends, > >Excuse me for this dumb question, how do I display the instance name in the >sql prompt. Have 3 DB and would like to know to which one I am connected. > >I mean something like that. > >DBA1 > >DBA2 > >DB01 > > >Regards, > >Ramon E. Estevez >[EMAIL PROTECTED] >Dominican Republic >809-565-3121 > > Make a difference, help support the relief efforts in the U.S. http://clubs.lycos.com/live/events/september11.asp -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: C.S.Venkata Subramanian INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).