Differences between drop, delete and truncate in oracle

The differences between drop, delete, and truncate in oracle are described as follows:
1. Both delete and truncate can delete the data in the table. However, compared with drop, the former only deletes the data and does not change the table structure. The latter also deletes the table structure; www.2cto.com 2. truncate has much higher performance than delete data,
The specific reason is: when the delete statement is used, the system processes records in the table one by one. before deleting rows from the table, record related delete operations and column values in the Delete row in the transaction processing log so that you can use the transaction processing log to recover data when the deletion fails. The truncate statement is used to delete all data pages related to the table at one time. In addition, the truncate table statement does not update the transaction processing log. After the data is deleted from the table using the truncate table statement, you cannot use the rollback command to cancel row deletion. Honeybinshun