恢复已经删除的记录 oracle

select * from VIP_BSW_XML t
insert into VIP_BSW_XML (select * from VIP_BSW_XML as of timestamp to_Date('2015-06-25 09:30:00', 'yyyy-mm-dd hh24:mi:ss'))
select * from VIP_BSW_XML as of timestamp to_Date('2015-06-25 09:30:00', 'yyyy-mm-dd hh24:mi:ss')
posted @ 2015-06-25 09:48  llhl  阅读(98)  评论(0编辑  收藏  举报