Answers

Question and Answer:

  Home  Database Management

⟩ What is the difference between delete and truncate?

Truncate is a DDL command, which has autocommit hence

cant be rolled back where as delete is DML with user commit

& roll back option. Truncate is faster then delete since it

wont store any data to backup tablespace. before delting.

 130 views

More Questions for you: