Skip to Main Content
Oracle SQL*Plus: The Definitive Guide
book

Oracle SQL*Plus: The Definitive Guide

by Jonathan Gennick
March 1999
Intermediate to advanced content levelIntermediate to advanced
528 pages
14h 39m
English
O'Reilly Media, Inc.
Content preview from Oracle SQL*Plus: The Definitive Guide

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. ...

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: The Definitive Guide, 2nd Edition

Oracle SQL*Plus: The Definitive Guide, 2nd Edition

Jonathan Gennick
Oracle PL/SQL Programming, Third Edition

Oracle PL/SQL Programming, Third Edition

Steven Feuerstein, Bill Pribyl
Oracle SQL

Oracle SQL

Dan Hotka

Publisher Resources

ISBN: 1565925785Supplemental ContentCatalog PageErrata