Suppress Duplicate Values in Oracle
Posted April 18, 2007on:
In the below example, we can suppress duplicate values in the MGR column, display a blank line between manager number groups, and suppress the display of repeated values in the DEPTNO column using the BREAK command.
SQL> BREAK ON mgr SKIP 1 ON deptno
when the query executes, the report output is organized based on the specifications you made in the BREAK command.