Re: How to set SQLPROMPT

This is in my glogin.sql file.

set termout off
spool temp_prompt.sql
select 'set sqlprompt '||''''||upper(user)||'@'||upper(name)||'> '||''''||chr(10)
from v$database;
spool off
start temp_prompt.sql
set termout on

set heading off
select 'Currently logged in to '||name||' database' from v$database;
set heading on

Mimmo Sime1 <csime1_at_xxx.it> wrote in message news:9q1d4q$al6$1_at_pegasus.tiscalinet.it...
> Hello everyone!
> I've got a quick question for you all:
>
> How can i set "SQLPROMPT" (from login.sql) with a variable valorized with
a
> query?
> In a few words: i'd like tu set SQLPROMPT with the result of "select
> global_name from global_name"...
>
>
> TIA! :)
>
>
Received on Wed Oct 10 2001 - 09:56:28 CDT