Loading…

Explain the difference between delete and truncate?

S.no TRUNCATE DELETE
1. Rollback of the data is not possible Rollback of the data is possible
2. All the records are deleted Can delete a specific record using the WHERE condition.
3. Uses less transaction space Use more transaction space

Suggest An Answer

No suggestions avaliable!

Latest post from Oracle Interview Questions

Ask Question