Re: SQLPlus prompt

From: Venkat <no_spamvreddy_at_ix.netcom.com>
Date: Mon, 11 May 1998 17:41:11 -0400
Message-ID: <6j7rdt$e5h@sjx-ixn10.ix.netcom.com>

I use the following in glogin.sql or login.sql ($oracle_home\dbs\)

set termout off
col curr_user new_value cu
col gname new_value gn
select user curr_user from dual;
select global_name gname from global_name; set termout on
set sqlprompt "&&cu@&&gn>"

global_name is not exactly SID but you could try selecting db_name from v$parameter - not everyone has permission to v$parameter though. Venkat

>I'd like to change the prompt SQL> of SQLPlus. So I want to visualize the
>prompt SQL_<istance_name> instead of SQL>.
>There's somebody that know how help me.
>
>Thanks in advance
>
>Sbaiz P.
Received on Mon May 11 1998 - 16:41:11 CDT