–查询是否开启闪回，0为关闭，1为打开。
select para_name,para_value from v$dm_ini where para_name=‘ENABLE_FLASHBACK’;

–开启闪回
SP_SET_PARA_VALUE(1,‘ENABLE_FLASHBACK’,1);

–创建测试表
create table ADDRESS5 AS SELECT * FROM ADDRESS;

–查询当前时间
SELECT SYSDATE;

–插入数据
insert into ADDRESS5 VALUES(20,‘HAHA’);
insert into ADDRESS5 VALUES(21,‘HEHE’);
SELECT * FROM ADDRESS5;