SQL*Plus Tutorial

SQL*Plus BREAK Command

The command BREAK specifies where and how formatting will change in a report.

BREAK Command syntax

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

The command BREAK determines:

- Dividing lines into sections and suppressing duplicate values;

- Insert a blank line every time the value of a column data changes;

- Display values calculated by the COMPUTE command to change the value of a column or at the end of the report.

BREAK Command example

BREAK ON price SKIP 1 ON product SKIP 1 DUPLICATES
COMPUTE SUM OF price_amount ON price
COMPUTE AVG OF price_amount ON product
SELECT price, product, price_amount
FROM PRODUCTS ;