=======================批量删除，只留前十条数据。
delete from THIRD_PARTY_MERCHANT a where a.rowid in
(
select rowid from THIRD_PARTY_MERCHANT
minus
select rowid from THIRD_PARTY_MERCHANT where rownum <10
)
原文：http://www.cnblogs.com/21heshang/p/6085299.html