oracle 回退表数据

-- 查看某条记录插入数据的时间
    select t.*,t.rowid from emp1 t;
    insert into emp1(empno,ename,hiredate,job,sal,deptno) values('8888','广西外国语',to_date('2020/4/19','yyyy/MM/dd'),'公司小职员','5000','10');
    select to_char(scn_to_timestamp(ORA_ROWSCN),'yyyy-MM-dd HH24:mi:ss:ff8') insert_time from emp1 t where t.empno = '8888';
    
-- 回退表数据
    alter table emp1 enable row movement;
    flashback table emp1 to timestamp to_timestamp('2020-04-19 10:19:20','yyyy-MM-dd HH24:mi:ss');

1、select t.*,t.rowid from emp1 t;

2、insert into emp1(empno,ename,hiredate,job,sal,deptno) values('8888','广西外国语',to_date('2020/4/19','yyyy/MM/dd'),'公司小职员','5000','10');

   3、select to_char(scn_to_timestamp(ORA_ROWSCN),'yyyy-MM-dd HH24:mi:ss:ff8') insert_time from emp1 t where t.empno = '8888';

4、执行下列语句

alter table emp1 enable row movement;
flashback table emp1 to timestamp to_timestamp('2020-04-19 10:30:20','yyyy-MM-dd HH24:mi:ss');

5、效果图