SQLPROMPT in Sql*Plus
From: Zbrk <zivjeli_at_veselili.se>
Date: Fri, 21 Jun 2002 15:00:19 +0200
Message-ID: <aev81o$4rr14_at_ns4.bih.net.ba>
Date: Fri, 21 Jun 2002 15:00:19 +0200
Message-ID: <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 Fri Jun 21 2002 - 15:00:19 CEST