Friday, 2 November 2012

What is difference between TRUNCATE & DELETE? | Oracle 10g

TRUNCATE commits after deleting entire table i.e., cannot be rolled back.
Database triggers do not fire on TRUNCATE
DELETE allows the filtered deletion. Deleted records can be rolled back or committed.
Database triggers fire on DELETE.

No comments: