SQLPlus Break

BREAK Command Syntax:

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

report_element – {column|expr|ROW|REPORT}
action – [SKI[P] n|[SKI[P]] PAGE][NODUP[LICATES]|DUP[LICATES]]

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 offer_id SKIP 1 ON product_id SKIP 1 DUPLICATES
COMPUTE SUM OF offer_amount ON offer_id
COMPUTE AVG OF offer_amount ON product_id
SELECT offer_id, product_id, offer_amount, customer_name,
FROM CUSTOMERS_VIEW ;