Jul 29, 2020 in Oracle
Q: Q. What is the difference between TRUNCATE & DELETE command in Oracle?

1 Answer

0 votes
Jul 29, 2020

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.
Click here to read more about Loan/Mortgage
Click here to read more about Insurance

Related questions

+1 vote
Jul 29, 2020 in Oracle
0 votes
Jul 29, 2020 in Oracle
...