see Connors excellent answer at the co-operative FAQ
http://www.jlcomp.demon.co.uk/faq/sqlplus_prompt.html
--
Niall Litchfield
Oracle DBA
Audit Commission UK
"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 - 08:43:04 CDT
