DEVFYI - Developer Resource - FYI

What is the difference between TRUNCATE and DELETE commands?

PL/SQL Interview Questions and Answers


(Continued from previous question...)

What is the difference between TRUNCATE and DELETE commands?

TRUNCATE is a DDL command whereas DELETE is a DML command. Hence DELETE operation can be rolled back, but TRUNCATE operation cannot be rolled back. WHERE clause can be used with DELETE and not with TRUNCATE.

(Continued on next question...)

Other Interview Questions