+1 vote
in Oracle by
Q. What is the difference between TRUNCATE & DELETE command in Oracle?

1 Answer

0 votes
by

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.

Related questions

+1 vote
asked Jan 21, 2021 in C Plus Plus by SakshiSharma
0 votes
0 votes
asked Jul 29, 2020 in Oracle by Hodge
...