17,377
社区成员
发帖
与我相关
我的任务
分享
delete tb1
where rowid in (select rowid from (select rownum as rm,rowid from tb1) where rm > 1400)
delete from tb1
where rowid in (select rowid from tb1
minus
select rowid from tb1 as of timestamp to_timestamp('2007-05-12 13:22:33', 'YYYY-MM-DD HH24:MI:SS'))
-- 如果 operdate 是你的插入日期, 可以用下面的方法删除 。
-- 之前最好 select 一下,使用同样的条件 。
delete tb1
where operdate between to_date('2014-11-26 00:00:00,''yyyy-mm-dd hh24:mi:ss)
and to_date('2014-11-26 23:59:59,''yyyy-mm-dd hh24:mi:ss)
select * from tb1
minus
select * from tb1 as of timestamp to_timestamp('2007-05-12 13:22:33', 'YYYY-MM-DD HH24:MI:SS')
--时间自行调整