Hello, if I mistakenly delete all the data in the table by omitting "WHERE", how can I undo that?

Answer 1

If you use oracle and flashback
check for something like :

Insert into <new_table>
(select * from <table> as of timestamp systimestamp - interval '1' day);

Make a wish to work ...

If you don;t keep backup and you commit the changes it is difficult to undo :(

Answer 2

Thanks