oracle数据库怎么查看被删除数据记录的表

网站编辑2023-06-25 16:13:12299

1. 查看被删除数据记录的表：

``` SELECT tablename, * FROM tablename WHERE id IN ( SELECT id FROM tablename UNION ALL SELECT id, tablename FROM tablename WHERE id IN ( SELECT id FROM tablename UNION ALL SELECT id, tablename FROM tablename WHERE id IN ( SELECT id FROM tablename UNION ALL SELECT id, tablename FROM tablename WHERE id IN ( SELECT id FROM tablename WHERE id IN ( SELECT id FROM tablename UNION ALL ) ) GROUP BY tablename HAVING id = ( SELECT id FROM tablename UNION ALL SELECT id, tablename FROM tablename WHERE id IN ( SELECT id FROM tablename WHERE id IN ( SELECT id FROM table_name UNION ALL ) )

GROUP BY table_name ```

2. 删除被删除数据记录的表：

DELETE FROM table_name WHERE id IN ( DELETE FROM table_name WHERE id IN ( DELETE FROM table_name WHERE id IN ( DELETE FROM table_name WHERE id IN ( SELECT id FROM table_name UNION ALL ) )

以上代码使用了 UNION 关联表的方式，将要删除的数据记录的表与该表的关联行删除。可以通过查看被删除数据记录的表的结构来确定具体的删除操作。