2015年7月13日
闪回查询（SELECT AS OF）
摘要： 使用Flashback Query的场景包括如下： 摘自官档 Recovering lost data or undoing incorrect, committed changes. For example, if you mistakenly delete or update rows, and then commit them, you can immediately undo the m... 阅读全文
posted @ 2015-07-13 16:26 hao_xiaoyu 阅读(1881) 评论(0) 推荐(0)
闪回事务查询
摘要： 原理：基于undo 闪回事务查询可以看作一个在事务级别查询数据库改变的一个诊断工具 FLASHBACK_TRANSACTION_QUERY retrieve transaction information for all tables involved in a transaction. provides the SQL statements that you can use to undo... 阅读全文
posted @ 2015-07-13 12:57 hao_xiaoyu 阅读(905) 评论(0) 推荐(0)