Re: SQL*Plus - Page Numbering
Date: 1996/07/13
Message-ID: <4s8m5r$hl7_at_lore.interserv.net>#1/1
> starlite_at_sun.cc.westga.edu () writes:
> 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
>
>>>>
Look into the break command. It can force a page break. I don't know of a
way to reset the page numbers in the middle of a select. I think it will be reset to 1
when a new select starts, if embedded is set to off.
Paul Smith
SCT International
Manchester, UK
psmith_at_sprynet.co.uk
Received on Sat Jul 13 1996 - 00:00:00 CEST