摘要: 1. 授予行迁移权限 alter table table_name enable row movement; 2. 到15分钟前: flashback table order to timestamp systimestamp - interval '15' minute; 到某个时间点: FLAS 阅读全文
posted @ 2017-06-26 16:19 为了八千块 阅读(286) 评论(0) 推荐(0) 编辑
摘要: 方法一: delete from dbyh where yhbh in(select yhbh from dbyh group by yhbh having count(*)>1) androwid not in (select min(rowid) from dbyh group by yhbh 阅读全文
posted @ 2017-06-26 09:20 为了八千块 阅读(376) 评论(0) 推荐(0) 编辑