To: "Sankar, Praim"
On Tue, 28 Sep 1999, Sankar, Praim wrote:
> I am creating a report using SQL Plus. I am using the following set
> commands.
>
> clear buffer
> col TODAY noprint new_value the_date FORMAT A8
> set embedded off
> set echo off
> set feedback on
> set pagesize 34
> set newpage 1
> set space 2
> set linesize 215
> set wrap off
> set numwidth 12
>
> The first and 2nd pages print correctly with the headers at the top but
> from the 3rd page on some data are at the top of the page followed by
> the heading.
>
> Thanks
It sounds like your PAGESIZE setting is off by one or two. Based on what
you are saying - that on the third page the heading is shifted down, I
would try:
SET PAGESIZE 33
Try printing again. If this does not work, try 32. Hope that this helps!
Best regards,
-Ari Kaplan
Independent Oracle DBA Consultant
<-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><->
<-> For 325+ Oracle tips, visit my Web Page: <->
<-> <->
<-> http://www.arikaplan.com <->
<-> <->
<-> email: akaplan@interaccess.com <->
<-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><->
Back to Ari Kaplan's Home Page