Difference between delete and truncate commands in sql
Hi friends,In this article i would like to explain delete and trncate commands.
Delete:
a) It is DML command and speed is slow.
b) Remove rows one by one and we can use where clause
c) we can rollback and fires trigger.
Truncate:
a) It is DDL command and speed is faster.
b) Remove all rows in one execution and we can't use where clause.
c) We can't rollback and does't fire trigger.
Tags: D/B Delete and Truncate Commands Oracle