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

From: shuan.tay$PCI鄭祺勛$ <shuan.tay_at_pci.co.id>
Date: Mon, 17 Feb 2003 15:53:46 -0800
Message-ID: <F001.0054FAAB.20030217155346@fatcity.com>

mm...
what if i logged in with SYSTEM first then "conn sys/pswd_at_db"? it's still show SYSTEM @db.

Original Message ----- From: Rajesh Dayal To: Multiple recipients of list ORACLE-L Sent: Saturday, February 15, 2003 6:53 PM Subject: RE: how to make sql prompt like 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') || '@' || 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> ?

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: =?utf-8?Q?shuan.tay\=28PCI=E9=84=AD=E7=A5=BA=E5=8B=9B\=29?=
  INET: shuan.tay_at_pci.co.id

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 Mon Feb 17 2003 - 17:53:46 CST