Unanswered: Rterieving data before committing a transaction.
After a successful transaction (after committing), i found that i sent wrong records of one the column (wrongly updated). How do i get back my initial stage? i mean, how do i get back all the previous results? Is there a way to retrieve my previous data which were before committing a transaction?
Note, that data obtained will be exactly the same as before that wrong transaction commit; any other changes made from that time will not be reflected in those techniques. So, if you/anybody else made any other changes after that wrong transaction, you will lose them with flashback table. In flashback query, you may be more successful by selecting primary key with wrong column/rows and recovering only them.
If this not possible, the other option would be recovering it from backup (again, only data before that wrong transaction). You should ask your DBA for doing that.