-- 查看某条记录插入数据的时间
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、效果图