Hi,
break on ... is a command of SQL*Plus and has nothing to do with SQL.
You cannot suppress duplicate values in a resultset of a single SQL query.
Ales