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
|