What is the difference between TRUNCATE & DELETE command in Oracle?

Question

Q. What is the difference between TRUNCATE & DELETE command in Oracle?

Answer 1

Both the commands are used to remove data from the database.

The difference between the two include:

• TRUNCATE is a DDL operation while DELETE is a DML operation.
• TRUNCATE drops the structure of a database and hence cannot be rolled back while the DELETE command can be rolled back.
• The TRUNCATE command will free the object storage space while the DELETE command does not.