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

I'd follow Tom Kyte's advice-

http://asktom.oracle.com/pls/ask/f?p=4950:8:::::F4950_P8_DISPLAYID:446220075876 connect.sql is something I wrote that just does:

connect &1
@login

Now, instead of typing "connect scott/tiger_at_someDb", you type "@connect scott/tiger_at_someDb".

At 04:53 PM 2/17/2003, shuan.tay\(PCI鄭祺勛\) wrote:
>mm...
>what if i logged in with SYSTEM first then "conn
><mailto:sys/pswd_at_db>sys/pswd_at_db"?
>it's still show SYSTEM @db.
>----- Original Message -----
>From: <mailto:Rajesh_at_ohitelecom.com>Rajesh Dayal
>To: <mailto:ORACLE-L_at_fatcity.com>Multiple recipients of list ORACLE-L
>Sent: Saturday, February 15, 2003 6:53 PM
>Subject: RE: how to make sql prompt like
><mailto:USER_at_DATABASE>USER_at_DATABASE> ?
>
>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') ||
><mailto:'@'>'@' || 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-----
>From: root_at_fatcity.com [mailto:root_at_fatcity.com]On Behalf Of Salaheldin
>Aboali
>Sent: Saturday, February 15, 2003 2:14 PM
>To: Multiple recipients of list ORACLE-L
>Subject: how to make sql prompt like USER_at_DATABASE> ?
>
>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>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

Justin Cave
Distributed Database Consulting

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Justin Cave
  INET: jcave_at_cableone.net

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