From: Lando <MarkL@quebim.com>
Subject: Re: UNIX like Prompt
Date: 1997/10/10
Message-ID: <343E6EFE.2AFC7FB2@quebim.com>#1/1
References: <61lad4$rpe@drn.zippo.com>
X-Priority: 3 (Normal)
X-Complaints-To: usenet@pppl.gov
X-Trace: tom.pppl.gov 876506868 19406 (None) 198.140.134.42
Organization: Princeton Plasma Physics Laboratory
Reply-To: MarkL@quebim.com
Newsgroups: comp.databases.oracle.server



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