Re: SQL*Plus login message

From: Alan D. Mills <alanmNOSPAM_at_uk.europe.mcd.mot.com>
Date: Thu, 16 Jul 1998 11:46:04 +0100
Message-ID: <6oklll$nnk$1@schbbs.mot.com>

This is just a guess as I haven't tried it but couldn't you run SQL*Plus with the silent (-s) option to stop the 'normal' sign on message appearing and then display your own custom message from within your login.sql script using the PROMPT command.

--
Alan D. Mills

Harry Mah wrote in message <35acbd08.0_at_champ>...
>Hello:
>
>When one logs onto an Oracle database using SQL*Plus, we usually get a
>message like: Connected to:
> Oracle....Server Release ...
> PL/SQL ...Production
>
> SQL>
>
>How do I add a personalized message like this when one logs on using
>SQL*Plus?
>
>Thanks
>Harry
>
>
Received on Thu Jul 16 1998 - 05:46:04 CDT