BREAK
The BREAK command is used to define page breaks and line breaks based on changing column values in a report. It controls whether or not duplicate values print in a column, and it controls the printing of computed values such as totals and subtotals. Chapter 3, demonstrates the use of this command.
The BREAK command looks like this:
BRE[AK] [ON {column_name|ROW|REPORT}
[SKI[P] {lines_to_skip|PAGE}|
NODUP[LICATES]|
DUP[LICATES]...]...]where:
- BRE[AK]
May be abbreviated BRE. Issuing the BREAK command with no parameters causes SQL*Plus to display the current break setting.
- column_name
Specifies a report column to watch. When the value in the column changes, SQL*Plus skips lines or pages as specified. SQL*Plus also inhibits repeating, or duplicate, values from printing more than once unless the DUPLICATES keyword is used.
- ROW
Causes SQL*Plus to break on each row. You could doublespace a report by using BREAK ON ROW SKIP 1.
- REPORT
Specifies a report-level break, and is used to cause SQL*Plus to print grand totals at the end of the report. SKIP PAGE will be ignored if it is specified as a report break action, but, strangely enough, the other form of the SKIP parameter will work. You can skip lines on a report break.
- SKI[P] lines_to_skip
Tells SQL*Plus to skip the specified number of lines when a break occurs. SKIP may be abbreviated to SKI.
- SKI[P] PAGE
Tells SQL*Plus to advance to a new page when a break occurs.
- NODUP[LICATES]
Tells SQL*Plus to print a column’s value only when it changes. ...