=======================批量删除，只留前十条数据。

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
)

oracle增删改查