Re: UNIX like Prompt

This should give you a start:

spool SETP
set heading off
set feedback off
set term off
select distinct 'SET SQLPROMPT '||Name||'/'||User||'/'||'SQL>' FROM V$DATABASE;
spool off
@@SETP.lst

set heading on
set feedback on
set term on

This will need to be included in glogin.sql.

cmb_at_msic.dia.mil wrote:

> I am looking for a way to change the sqlplus/svrmgrl
> prompt from the non-informational one to a UNIX like
> one. That is, it displays the SID,and Oracle user/role
> the application developer session currently displayed
> in the window. What and where are the changes to be made
> for dbas in svrmgrl and appdevs in sqlplus?
>
> Thanks
Received on Fri Oct 10 1997 - 00:00:00 CDT