本文介绍了一段SQL查询代码，该代码用于从用户回收站中选择原始名称以'FINANCE_'开头的对象，并按删除时间降序排列。此外，还展示了如何使用闪回功能恢复已删除的tm_customer_address表。
SELECT *
FROM user_recyclebin
WHERE original_name LIKE 'FINANCE_%'
ORDER BY droptime DESC;
flashback TABLE tm_customer_address TO BEFORE drop
FROM user_recyclebin
WHERE original_name LIKE 'FINANCE_%'
ORDER BY droptime DESC;
flashback TABLE tm_customer_address TO BEFORE drop
扫一扫
2361
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
