SQL Plus - Break

Card Puncher Data Processing

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

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





Discover More
Card Puncher Data Processing
SQL Plus - Clear

CLEAR resets or erases the current value or setting for the specified option. where option represents one of the following clauses: BRE[AKS] BUFF[ER] COL[UMNS] COMP[UTES] SCR[EEN] SQL...
Card Puncher Data Processing
SQL Plus - Command Reference

Commands Description @ @@ / ACCEPT APPEND ARCHIVE ATTRIBUTE BREAK BTITLE CHANGE CLEAR COLUMN COMPUTE CONNECT COPY Copies data from a query to a table in the same or another...
Card Puncher Data Processing
SQL Plus - Compute

COMPUTE in combination with the BREAK command, calculates and prints summary lines using various standard computations. The following summary function are available: SUM : Sum of the values in...
Card Puncher Data Processing
SQL Plus - Formatting Reports

How to format SQLplus output (ie ) All below parameters can be configured in the login script. Through the SQLPlus COLUMN command with the heading options, you can change the column headings...



Share this page:
Follow us:
Task Runner