查看X分钟前的表数据
SELECT * FROM 表名 AS OF TIMESTAMP (SYSTIMESTAMP - INTERVAL '10' MINUTE)
建立临时表将X分钟前的数据放到临时表中
create table aaa as
SELECT * FROM 表名 AS OF TIMESTAMP (SYSTIMESTAMP - INTERVAL '10' MINUTE)
查看X分钟前的表数据
SELECT * FROM 表名 AS OF TIMESTAMP (SYSTIMESTAMP - INTERVAL '10' MINUTE)
建立临时表将X分钟前的数据放到临时表中
create table aaa as
SELECT * FROM 表名 AS OF TIMESTAMP (SYSTIMESTAMP - INTERVAL '10' MINUTE)