Re: ??Form feed in SQL*Plus??

Gus Spier wrote:

> The real question is, "Does anybody have a copy of SQL*Plus Users' Guide
> (version 3.1.x.x) they can bear to part with? I'll pay real money."
>
> The immediate question is, "What option is required in the BREAK
> statement to get a new page started?" As an example,
>
> break on COL1 skip 1 on COL2 on COL3 ?form feed" on COL4 ...
>
> Pls e-mail as well as post and I'll summarize the responses for thre
> group.

Inserting Space when a Break Column's Value Changes

You can insert blank lines or begin a new page each time the value changes in the break column. To insert n blank lines, use the BREAK command in the following form:

BREAK ON break_column SKIP n

To skip a page, use the command in this form:

BREAK ON break_column SKIP PAGE

---
Name   : Lun Wing San
Title  : Oracle Application Developer of Hong Kong Productivity Council
         Oracle Database Administrator and System Administrator of QRC
Phone  : (852)27885841