Answer Detail: RE: What is difference between TRUNCATE & DELETE

GeekInterview.com > Interview Questions > Oracle > SQL Plus

Print |

Question: What is difference between TRUNCATE & DELETE

Answer:
Answer posted by Scott on 2005-05-25 18:30:04: TRUNCATE is a DDL command and cannot be rolled back. All of the memory space is released back to the server.
DELETE is a DML command and can be rolled back.

Both commands accomplish identical tasks (removing all data from a table), but TRUNCATE is much faster.

December 12, 2005 04:10:23	#10
Deepika S. Verma	Member Since: Visitor Total Comments: N/A
RE: What is difference between TRUNCATE & DELETE
The Main Difference Between DELETE & TRUNCATE Are :- [1] DELETE - is a DML Command & TRUNCATE - is a DDL Command [2] After DELETE - can rollback the Records & After TRUNATE - cannot rollback the records [3] In DELETE Command you can give the conditions in WHERE Clause & In TRUNCATE you cannot give conditions [4] After using DELETE Command The memory will be occupied till the user does not give ROLLBACK or COMMIT & After using TRUNCATE Command The memory realeased immediately

Back To Question