Re: SQL*Plus login message

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 - 10:07:25 CDT