Re: SQLPROMPT in Sql*Plus

hi,

try including this in your login.sql

column a1 new_value prmpt
set termout off
select name || '> ' a1 from v$database;
set termout on
set sqlprompt "&&prmpt"
undef prmpt

hope this helps...

regards,
bliss

"Zbrk" <zivjeli_at_veselili.se> wrote in message news:aev81o$4rr14_at_ns4.bih.net.ba...
> Can I set a sqlprompt in Sql*Plus to value from a variable. I wish to have
> database global_name in the sqlprompt.
> I have tried by creating login.sql file like this but it doesn't work:
>
> var c varchar2(30)
> exec select * from into c from global_name;
> set sqlprompt :c
>
> Thanx
>
>
Received on Sat Jun 22 2002 - 06:02:56 CEST