Re: Who knows the answer?

This method requires no access to any v$ tables .. can be used by anyone connected to oracle. This will set the prompt to the dbname and the user id.

set termout off

column sprompt noprint new_value s_prompt

select substr(global_name,1,(instr(global_name,'.') - 1))||'('||user||')'||'>' sprompt
  from global_name,

       (select user from dual);

set sqlprompt &s_prompt

set termout on Received on Thu Sep 23 1999 - 17:31:32 CDT