I had written a plsql block which will delete the duplicate data in a table. Since the logic that I have written is wrong, some original data is also deleted and the changes are committed. Please advice me on how I can revert the committed data changes and also advice me on how to delete duplicates
Flasback query will be used to revert the commited changes in oracle. Please google on how to user falsback query in oracle