Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: SQL*Plus login message
There was a very recent post on this - search DejaNews. Sorry - I don't
remember the details on how.
--
Matt Brennan
SQL*Tools Specialist
GERS Retail Systems
9725-C Scranton Road
San Diego, California 92121
1-800-854-2263
mbrennan_at_gers.com
(Original email address is spam-blocked.)
Dave Best <davidbe_at_nortel.ca> wrote in article <35AE172D.16B7_at_nortel.ca>...
> Alan D. Mills wrote:
> >
> > 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.
> >
>
> 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
>
> --
> Dave Best
> DtM IEDB Operations
> Information Services, Nortel
> Ottawa, Canada
> External: (613) 765-6131
> ESN: 39-56131
> davidbe_at_nortel.ca
>
Received on Thu Jul 16 1998 - 17:33:14 CDT