DEVFYI - Developer Resource - FYI

What is the difference between deleting and truncating of tables

ORACLE Interview Questions and Answers (Part 4)


(Continued from previous question...)

620. What is the difference between deleting and truncating of tables

Deleting a table will not remove the rows from the table but entry is there in the database dictionary and it can be retrieved But truncating a table deletes it completely and it cannot be retrieved.

(Continued on next question...)

Other Interview Questions