0

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

23rd Apr 2019, 1:02 PM
Isheka M. A. Turay
Isheka M. A. Turay - avatar
2 Respuestas
+ 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 :(
23rd Apr 2019, 1:10 PM
Prokopios Poulimenos
Prokopios Poulimenos - avatar
0
Thanks
23rd Apr 2019, 1:59 PM
Isheka M. A. Turay
Isheka M. A. Turay - avatar