Please help the master oracle, I want to ask.
how to reverse the data that has been committed to the Toad.
Toad is nothing more than a tool to allow you to develope database
applications, and maintain them, and the databases underneath.
To this end, it’s not possible to commit data to Toad itself, however,
you can commit data changes to a database connection that you have open
in Toad - this is what I think you mean. (I understand that English may
not be your first language.)
If we assume that you have made a few changes and then clicked on the
COMMIT button (or executed the COMMIT command) then you need to manually
undo your changes yourself and then COMMIT again.
Once you have committed some changes, that’s it, they are permanent.
However, depending on the version of the database, you may be able to
ask your DBA to flashback the database to a specific point in time, or,
assuming you are using hot backups, restore the database to a point
prior to your changes being made. However, these options will also roll
back changes made by other people on the database - which may not be
If the database is set up with flashback enabled for tables, you could
flashback the table(s) to before your updates, open a cursor to the
flash backed table, then close the flashback session.
Then you can read the data from the cursor (still as it was before you
made changes) and rebuild either the existing table(s) or build a new
one and use that to correct your changes.