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
Leave a Comment