Question: what is the difference between truncate and delete in oracle?
Answer: TRUNCATE removes all rows from a table. The operation cannot be rolled back and no triggers will be fired. ... DROP and TRUNCATE are DDL commands, whereas DELETE is a DML command. Therefore DELETE operations can be rolled back (undone), while DROP and TRUNCATE operations cannot be rolled back.