刚刚误把正式当测试删除了好多数据，好慌，幸好找回了，这里记录一下
SELECT * FROM TABLE_NAME AS OF TIMESTAMP TO_TIMESTAMP(time,'yyyy-mm-dd hh24:mi:ss'); --time指某个时间点之后删除的数据如：SELECT * FROM SCOTT.TEST AS OF TIMESTAMP TO_TIMESTAMP('2009-12-11 20:53:57','yyyy-mm-dd hh24:mi:ss'); 本文共 291 字，大约阅读时间需要 1 分钟。
刚刚误把正式当测试删除了好多数据，好慌，幸好找回了，这里记录一下
SELECT * FROM TABLE_NAME AS OF TIMESTAMP TO_TIMESTAMP(time,'yyyy-mm-dd hh24:mi:ss'); --time指某个时间点之后删除的数据如：SELECT * FROM SCOTT.TEST AS OF TIMESTAMP TO_TIMESTAMP('2009-12-11 20:53:57','yyyy-mm-dd hh24:mi:ss'); 转载于:https://www.cnblogs.com/dbqjava/p/6296801.html