Oracle’s PL/SQL questions

Difference between truncate and delete?

Posted by silpa on Sep 11 2007

Truncate is a DDL command.It deletes complete table data and no rollback is possible.Also resets the high water mark.

Delete is a DML command.It required commit to make changes permanently.No effect is there on high water mark