Truncate deletes all the records at one go delete statement can delete specific rows or all rows.

Truncate is DDL and delete is DML

Truncate delete

it remove delete keep the tablespace

table space

DELETE: You can rollback

TRUNCATE : You can't rollback

Sithu

delete is a dml statement

truncate is a ddl statement

delete is mainly used to delete the records truncate is used to dele the table completel y but structure remains same.

we can get back the deleted recods by using roll back command whereas rollback does not work for truncate

Truncate and Delete are used for deleting data

Difference is

• Auto commit in Truncate. No auto commit in Delete.
• Truncate is faster when compare to delete.
• Truncate -> High Water Mark set to ZERO

truncate is a DDL statement.Delete ia DML statement

Truncate works faster than delete as data need not be written to rollback segments.

Trunacte cannot be rolled back delete can be rolled back

Truncate releases storage space delete doesnt release storage space

Truncate does not work when foriegn key is enabled

Delete trigger does not fire on truncate

Truncate requires DELETE TABLE privilege if the user does not own the table