Re: SQL*Plus - Page Numbering

starlite_at_sun.cc.westga.edu wrote:
>
> In SQL*Plus is it possible to start renumbering pages based
> on a column break.
>
> We are listing Students within Majors, and after we finish a
> major and before starting the next major we would like to do
> a page break so that the new major can begin on a new page.
>
> Is this possilbe in SQL*Plus -- If so what is the syntax.
>
> Thanks
>
> Jeanette Eckles
> State University of West Georgia
> Carrollton GA 30118
> (770) 830-2275
> jeckles_at_westga.edu
> DBA/Programmer

To my early-Saturday-morning knowledge, you cannot dynamically start repaging in SQL*Plus. You would have to start with a new query which I assume is not an option...sorry...

Another option would be to use PL/SQL to create your results and you could store a page number in your report table for printing...good luck. Received on Sat Jul 13 1996 - 00:00:00 CEST