SQL Plus - Break

About

BREAK specifies where changes occur in a report and the formatting action to perform, such as:

• suppressing display of duplicate values for a given column
• skipping a line each time a given column value changes
• printing computed figures each time a given column value changes or at the end of the report (in combination with compute)

Articles Related

Syntax

BRE[AK] [ON report_element [action [action]]] ...

where:

• report_element has the following syntax:

 
{column | expression | ROW | REPORT}

• action has the following syntax:

[SKI[P] n | [SKI[P]] PAGE] [NODUP[LICATES] | DUP[LICATES]]

Example

See SQL Plus - Formatting Reports

How to

List all BREAKS

Enter BREAK with no clauses to list the current BREAK definition.

Suppress all Breaks

See clear

CLEAR BREAKS

breaks cleared