Re: Some questions on report output

On 2 Dec 1998 23:58:36 GMT, iancrozier_at_aol.com (Iancrozier) wrote:

>I am using:
>break on column1 page
>
>Is there a way to get the new page and still display all values of column1?

Yes, use the following break command:         

        break on column1 duplicates page

By default, SQL*Plus assumes NODUPLICATES.

>Question 2
>
>I am getting a new header and page number every time I use the above, but what
>I really want is
>a brand new page, so that when I print it will give me a new sheet of paper for
>every
>new value of column1. Is there a way to do this? Presently, I have pagesize set
>to 72
>and I thought that the appropriate number of blank lines would be inserted, but
>they're
>not. Any suggestions welcomed.

You might need to play around with SET NEWPAGE a bit.

SET NEWPAGE 0 -- Tells SQL*Plus to output a formfeed character for each new page.

SET NEWPAGE 1 -- Is the default setting, and tells SQL*Plus to print just one extra blank line when advancing to a new page.

If you have NEWPAGE set to anything other than 0, SQL*plus should print the required number of lines (based on PAGESIZE). Jonathan Received on Sat Dec 05 1998 - 22:15:09 CST