Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: SQL*Plus login message

Re: SQL*Plus login message

From: Shirley Burk <sburk_at_gte.net>
Date: Wed, 15 Jul 1998 20:09:46 -0400
Message-ID: <6ojgd6$ism$1@news-2.news.gte.net>


Harry,

You can "customize" your login for SQL*Plus by using a default login script in the default start-up directory.

Plus looks for a file called login.sql in this directory.

Here is what I have in mine.

set head off
set feed off
set serverout on size 100000
show user
show serverout

--

sburk_at_gte.net
--
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 Wed Jul 15 1998 - 19:09:46 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US