Syntax:
BRE[AK] [ON column_name [action [action]]...;

> Where:
action: [SKI[P] n | [SKI[P] PAGE] [NODUP[LICATES] | DUP[LICATES]]

Description:
The break command can be used to create report breaks. When value in a column changes a break event is generated and the action is executed. This way you can skip a line (SKIP 1) when a value changes in a column. In addition duplicate values can be suppressed (NODUP). You can specify more than one break column by adding more on clauses at the end.

Break setting will remain active for the remainder of the database session. When you connect again the break settings will be removed. You can also manually remove break settings by executing the clear breaks command.

> Executing a break command replaces the previous break settings.

Examples:
break on deptno skip 2 duplicates;
select * from emp order by deptno;

> break on job skip 1 nodup on deptno nodup;
select ename, job, deptno from emp order by job, deptno;

See also:

• Clear command
• Commands
• SQL*XL Home
• Features