数据库里表数据不小心被删除了 怎么解决
这个sql不对 要怎么修改
SELECT * FROM M_ENVIRONMENTAL_INGREDIENT_REGULATION AS OF timestamp to_timestamp('22-09-30 13:40:00','yyyy-mm-dd')
WHERE呢
两种方式都行
SELECT * FROM M_ENVIRONMENTAL_INGREDIENT_REGULATION AS OF timestamp to_date('2022-09-30 13:40:00','YYYY-MM-DD HH24:MI:SS');
select * from M_ENVIRONMENTAL_INGREDIENT_REGULATION as of timestamp sysdate - 10 / 1440 -- 当前时间十分钟前