Re: SQL*Plus login message

From: Alan D. Mills <alanmNOSPAM_at_uk.europe.mcd.mot.com>
Date: Fri, 17 Jul 1998 14:38:48 +0100
Message-ID: <6onk6a$quc$1@schbbs.mot.com>

try soemthing like this

col global_name new_value myprompt

select global_name || '> ' global_name
from global_name
/

set sqlprompt &myprompt

That should do it.
--
Alan D. Mills

Dave Best wrote in message <35AE172D.16B7_at_nortel.ca>...
>
> Is there any way to customize the SQL> prompt? Since we have a fair
>number of databases I wouldn't mind customizing it so that it tells you
>what
>DB you are connected to: ex: SQL-GlobalName>
>
>Thanks
>
>--
>davidbe_at_nortel.ca
Received on Fri Jul 17 1998 - 08:38:48 CDT