Re: UNIX like Prompt

Not every user will have access to the dynamic performance tables. This will work only for users with dba/system privileges.

Lando wrote:
>
> 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
 

-- 
*****************************************************************
"There are no strangers in life, only friends you've not yet met"
Srinivasan Sankar                         srinisankar_at_hotmail.com
*****************************************************************