DEVFYI - Developer Resource - FYI

What is difference between TRUNCATE & DELETE ?

ORACLE Interview Questions and Answers (Part 4)


(Continued from previous question...)

560. What is difference between TRUNCATE & DELETE ?

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

(Continued on next question...)

Other Interview Questions