SQL Plus - Break

> Procedural Languages > (SQL Plus|SqlCl) (Oracle Database Console)

1 - 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)
Advertising

3 - 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]]

4 - Example

See summary

5 - How to

5.1 - List all BREAKS

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

5.2 - Suppress all Breaks

See clear

CLEAR BREAKS
breaks cleared
Advertising