Re: SQL*Plus - Page Numbering

David Di Biaggio <dibiaggio_at_iquest.net> wrote:

>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
 

>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...

Actually, it's easy to do this in SQL*Plus. Just set a BREAK on the MAJOR column like this...

BREAK ON MAJOR SKIP PAGE; (this skips a page each time MAJOR changes) SET NEWPAGE 0; (this adds a formfeed character for each new page)

SQL*Plus has lots of great options like that. If you can get your hands on the SQL*Plus v2.3 User's Guide, it's packed full of how-to info. Unfortunately, the SQL*Plus 3.x guide is a barren reference manual only.

Chris

+------------------------------------+
| Chris Hamilton -- chamilto_at_xis.com |
| http://www.xis.com/~chamilto/      |
| City of Washington Pipe Band       |
+------------------------------------+