Tuesday, May 8, 2012

DML statements can be roll back but DDL can't be roll backed

DROP and TRUNCATE are DDL commands, 
whereas DELETE is a DML command.
Therefore DELETE operations can be rolled back (undone), while DROP and TRUNCATE operations cannot be rolled back.



From Oracle 10g a table can be "undropped". Example:
SQL> FLASHBACK TABLE emp TO BEFORE DROP;

Flashback complete.

1 comment: