Difference between truncate and delete

Question

Accepted Answer

Truncate is a DDL command that removes all rows from a table, while delete is a DML command that removes specific rows.

Truncate is faster than delete as it does not generate undo logs.
Truncate resets the high water mark of the table, while delete does not.
Truncate cannot be rolled back, while delete can be rolled back using a transaction.
Truncate does not fire any triggers, while delete does.
Truncate does not require a WHERE clause, while delete does.

Accepted Answer

Delete : it is Dml command, its support where condition, deleted data temporary, retrieve data by using roll back command, its process is slow.

Truncate : its ddl cmd, it doesn't support where condition, deleted data permanently and structure is there, its process is speed.

Popular interview questions of Oracle SQL and PLSQL Developer