Name
BREAK
Synopsis
BRE[AK] [ON {column_name | ROW | REPORT}
[SKI[P] {lines_to_skip | PAGE} |
NODUP[LICATES] |
DUP[LICATES]...]...]
The BREAK command is used to define page breaks and line breaks based on changing column values in a report. It controls whether duplicate values print in a column, and it controls the printing of computed values such as totals and subtotals. Issuing the BREAK command with no parameters causes SQL*Plus to display the current break setting. For example:
BREAK ON ROW SKIP 1 BREAK ON dept BREAK ON dept SKIP PAGE
Parameters
- column_name
Specifies a report column to watch. When the value in the column changes, SQL*Plus executes the specified break actions.
- ROW
Causes SQL*Plus to break on each row.
- 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, 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.
- 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. By default, whenever you put a break on a column, you get this behavior.
- DUP[LICATES]
Forces SQL*Plus to print a column’s value in every line on the report, regardless of whether the value is the same as that printed for the previous record.
Get Oracle SQL*Plus Pocket Reference now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.