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

From: Prem Khanna J <jprem_at_kssnet.co.jp>
Date: Mon, 17 Feb 2003 20:48:43 -0800
Message-ID: <F001.0054FCCE.20030217204843@fatcity.com>

Salaheldin Aboali ,

add the feww lines below to your
$ORACLE_HOME/sqlplus/admin/glogin.sql

---

set term off
column prompter new_value m_prompt

select username || '@' || name || '>' prompter

        from v$session,v$database;         

set sqlp '&m_prompt'
undefine m_prompt

commit;
set term on

---

Note: this will affect all the users connecting to the DB.

HTH.
Jp.

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

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Prem Khanna J
  INET: jprem_at_kssnet.co.jp

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 - 22:48:43 CST