Re: UNIX like Prompt

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

This should do it if your system is UNIX. I've noticed that it may come up short on NT (server value missing). If you are on NT and need that version e-mail my second address (work) and I will send it to you.

REM login.sql
set termout off
column glogin_prompt1 noprint new_value _glogin_prompt1 select substr(program,instr(program,'@')+1,instr(program,' ')-instr(program,'@')-1) ||

       ':' || value glogin_prompt1
from v$parameter,v$process where program like '%SMON%' and name='db_name';
column glogin_prompt2 noprint new_value _glogin_prompt2 select value glogin_prompt2 from v$parameter where name = 'compatible'; column glogin_prompt3 noprint new_value _glogin_prompt3 select sid glogin_prompt3 from v$session where audsid = userenv('sessionid');
column glogin_prompt4 noprint new_value _glogin_prompt4 select user glogin_prompt4 from dual;
column glogin_prompt5 noprint new_value _glogin_prompt5 select '&_glogin_prompt1' || ':' || ltrim('&_glogin_prompt2') ||

       '(' || ltrim('&_glogin_prompt3') || '):' || 
       ltrim('&_glogin_prompt4') glogin_prompt5 from dual;

set sqlprompt 'SQL@&_glogin_prompt5> '
REM EOF EOF EOF EOF

-- 
                           \\|//
                           (0-0)
           +---------oOO----(_)---------------+
           | Brian P. Mac Lean                |
           | Senior DBA                       |
           | brian.maclean_at_goodnet.com        |
           | brian.maclean_at_sendero.fiserv.com |
           +----------------------oOO---------+
                          |__|__|
                           || ||
                          ooO Ooo
 

 
"We trained hard, but it seemed that every time we were 
beginning to form into teams we would be reorganized.  
I was to learn later in life that we tend to meet any new
sitiation by reorganizing, and what a wonderful method it 
can be for creating the illusion of progress while producing 
confusion, inefficiency, and demoralization."
        Petronius Arbiter 210 B.C.