Question: what is the difference between delete drop and truncate in oracle?
Answer: The DROP command removes a table from the database. All the tables' rows, indexes, and privileges will also be removed. ... DROP and TRUNCATE are DDL commands, whereas DELETE is a DML command. DELETE operations can be rolled back (undone), while DROP and TRUNCATE operations cannot be rolled back.