本文介绍了一种解决因WHERE子句错误导致的数据误更新问题的方法。通过使用Oracle的闪回表功能，可以轻松地撤销错误的更新操作，并将表恢复到之前的状态。
514.A user performs an update on a table. Shortly after committing the transaction, they realize that they
had an error in their WHERE clause causing the wrong rows to be updated. Which Flashback option
would allow you to undo this transaction and restore the table to its previous state?
A. Flashback Drop
B. Flashback Query
C. Flashback Versions Query
D. Flashback Transaction Query
E. Flashback Table
Answer: E
答案解析：
参考：http://blog.csdn.net/rlhua/article/details/12404577
针对使用了错误的where子句进行更新，使用闪回表就可以了。
扫一扫
8873
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
