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