set head off
set pageline 0
before running your SQL script
try this , i think this should solve your problem
----- Original Message -----
From: "Bridget" <oracledba-ezmlmshield-x66324018.[Email address protected]
To: "LazyDBA Discussion" <[Email address protected]
Sent: Wednesday, March 30, 2005 3:44 AM
Subject: header information in sqlplus
> 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
>
>
>
>
> <font face="Times New Roman" size="3">
> <p>------------------------------------------------------------------------------</p>
> <p> This email is intended only for the use of the individual(s) to whom
> it is addressed and may be privileged and confidential. Unauthorised use
> or disclosure is prohibited. If you receive this e-mail in error, please
> advise immediately and delete the original message. This message may have
> been altered without your or our knowledge and the sender does not accept
> any liability for any errors or omissions in the message.</p>
> <p>====================================================</p>
> </font>
>
>
>
> --------
> 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