Answer Posted / ashu singh
Drop deletes the table along with its structure from the database.
Delete command deletes the records from the table and it also deletes the table space allocated in the database.
Truncate is similar to Delete but it does not delete the table space from the database.
Drop and Truncate are the DDL command hence can't be rolled back whereas Delete is a DML command and can be rolled back.
| Is This Answer Correct ? | 13 Yes | 2 No |
Post New Answer View All Answers
Is it possible to insert comments into sql statements return in the data model editor ?
Can a parameter be passed to a cursor?
How to loop through data rows in the implicit cursor?
Explain how are indexes update?
how the Oracle Prepares the Execution Plan and how it chooses the Optimal one?
When do I need to use a semicolon vs a slash in oracle sql?
What is the difference between truncate & delete command?
What is the difference between translate and replace?
How to convert characters to dates in oracle?
what is the difference between data migration and production migration.
What is SQL Tuning Advisor in Oracle?
How to delete a column in an existing table?
What is the difference between sharding and replication?
What is an oracle user account?
What is a dead lock in oracle?
