select t.first_load_time, t.*
from v$sqlarea t
where rownum < 20
and sql_text like '%set del_flag%'
order by t.first_load_time desc; --模糊搜索误执行的sql
select *
from TEST_TABLE --你操作的那张表
as of timestamp to_timestamp('2021-01-11 16:33:42', 'yyyy-mm-dd hh24:mi:ss');
create table TEST_TABLE_TMP as
select *
from TEST_TABLE --你操作的那张表
as of timestamp to_timestamp('2021-01-11 16:33:42', 'yyyy-mm-dd hh24:mi:ss');
Comments | NOTHING