Commit and Rollback defined the major difference between Truncate and Delete.
Delete: Delete command removes row from a table. After delete operation we can use commit and rollback to make the change permanent or undo it.
Truncate: Truncate removes all rows from a table. After truncate operation we can not use commit and rollback to make the change permanent or undo it.
Leave a comment: