Re: HELP! SQL*PLUS V3.0 suppress dups in break column...

You just need to change the 'order by' to a 'group by' and it should work ok...break needs know that the data is 'grouped' together. Also you might want to look at reworking your statement....like this:

BREAK ON FAC.fac_id nodup on FAC.fac_name nodup skip 1

select FAC_STA.fac_id,

             FAC.fac_name, 
             FAC_STA.sta_id
from     fac, 
            fac_sta
where  FAC_STA.end_rec_date is null
  and     FAC_STA.fac_id = FAC.fac_id
  and     FAC.end_rec_date is null
group by fac_sta.fac_id, 
               fac.fac_name, 
               fac_sta.sta_id;