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.