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)

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

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

Powered by ComboStrap