Skip to Main Content
Oracle SQL*Plus Pocket Reference
book

Oracle SQL*Plus Pocket Reference

by Jonathan Gennick
April 2000
Intermediate to advanced content levelIntermediate to advanced
94 pages
1h 52m
English
O'Reilly Media, Inc.
Content preview from Oracle SQL*Plus Pocket Reference

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.

Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Start your free trial

You might also like

Oracle SQL*Plus Pocket Reference, 3rd Edition

Oracle SQL*Plus Pocket Reference, 3rd Edition

Jonathan Gennick
Expert Oracle Exadata

Expert Oracle Exadata

Kerry Osborne, Randy Johnson, Tanel Pöder

Publisher Resources

ISBN: 1565929411Catalog PageErrata