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

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 ;