Set heading off

Also uselfull
Set feedback off -- 1 rows returned
Set pagesize 0 -- also stops feedback

Help
Show all


-----Original Message-----
From: marco
[mailto:oracledba-ezmlmshield-x96010367.[Email address protected]
Sent: Wednesday, March 30, 2005 7:10 AM
To: LazyDBA Discussion
Subject: Re: header information in sqlplus

Il mer, 2005-03-30 alle 13:44, Bridget ha scritto:
> Hi
>
>
> Could anyone tell me how do I remove the header information from
sqlplus. I've written a script that goes in a loop in and out sqlplus
with results I need , I would rather
> the header information below was not there, is there a flag or
something when starting up sqlplus ?
>
>
> thanks a mil
>
>
> B
>

> Connected to:
> Oracle7 Server Release 7.3.4.0.0 - Production
> With the distributed and Spatial Data options
> PL/SQL Release 2.3.4.0.0 - Production
>
>
> SQL> Disconnected from Oracle7 Server Release 7.3.4.0.0 - Production
> With the distributed and Spatial Data options
> PL/SQL Release 2.3.4.0.0 - Production
>


hi,
you should use sqlplus -s ......

regards
M.



--------
website: http://www.LazyDBA.com
Please don't reply to RTFM questions
Oracle documentation is here: http://tahiti.oracle.com
To unsubscribe: see http://www.lazydba.com/unsubscribe.html
To subscribe: see http://www.lazydba.com
By using this list you agree to these
terms:http://www.lazydba.com/legal.html


Oracle LazyDBA home page