RE: how to make sql prompt like USER@DATABASE> ?

From: Rajesh Dayal <Rajesh_at_ohitelecom.com>
Date: Sat, 15 Feb 2003 03:53:36 -0800
Message-ID: <F001.0054E8DB.20030215035336@fatcity.com>

You can add following lines to your glogin.sql ($ORACLE_HOME/sqlplus/admin directory) file.  

set heading off
set term off
set feedback off
spool myprompt.sql
select 'set sqlprompt "' || SYS_CONTEXT ('USERENV', 'session_user') || '@' || SYS_CONTEXT ('USERENV', 'DB_NAME') || '>"' from dual
/
spool off
@myprompt.sql
set heading on
set term on
set feedback on  

Alternatively you can create a file with above lines, put that file in bin and call it anytime to make your prompt…  

Cheers,
Rajesh  

----Original Message-----
Aboali
Sent: Saturday, February 15, 2003 2:14 PM To: Multiple recipients of list ORACLE-L  

hi
how to make sql prompt like USER_at_DATABASE> ? where USER: connected user
DATABASE: database global name, or database local alias Regards,
Salaheldin Aboali

---

Senior Software Developer
Management Information Systems
http://www.mis-kuwait.com
Phone:
+965.240.64.25
+965.240.67.98
+965.240.80.92

Ext. 235
Fax. +965.240.81.53
Cell. +965.790.31.65

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Rajesh Dayal
  INET: Rajesh_at_ohitelecom.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (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).

Received on Sat Feb 15 2003 - 05:53:36 CST