| 35. 6. 1. Query Flashbacks |
|
|
If you mistakenly commit changes and you want to view rows as they originally were, you can use a query flashback. |
You can then use the results of a query flashback to manually change rows back to their original values if you need to. |
In addition, flashbacks can be based on a datetime or system change number (SCN). |
The database uses SCNs to track changes made to data, and you can use them to flash back to a particular SCN in the database. |