diff between DELETE and TRUNCATE?.

Question Posted / guest

14 Answers
18138 Views
HCL, Yalamanchili Software, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

diff between DELETE and TRUNCATE?...

Answer / sandeep desai

Some more additions

With Truncate command Oracle sets the High Water Mark to
Zero
whereas
With Delete command this doesn't happen since data is not
released from the memory

Is This Answer Correct ?

0 Yes

0 No

diff between DELETE and TRUNCATE?...

Answer / chaitanyabilla

delete-low water mark level
truncate-high water level

Is This Answer Correct ?

0 Yes

0 No

diff between DELETE and TRUNCATE?...

Answer / sahaja mallarapu

Delete is a DML command.
Truncate is a DDL command.

Using delete we can delete specific rows by applying some
condition.
using truncate all rows are deleted. we cant apply any
condition here.

deleted rows can be rollbacked.
truncated rows cant be rollbacked.

memory occupied by deleted rows cant be reused.
memory occupied by truncated rows can be reused.

Is This Answer Correct ?

0 Yes

0 No

diff between DELETE and TRUNCATE?...

Answer / padma

delete comd is used to delete not a specific record rather
all records without affecting the structure of the records
truncate comd is used to delete all the records from
existing table,retaining the structure o that table.
by using delete comd v can rollback all the delete
records .it is record level cmd
wherease truncate cmd v cannot rollback. it is table
level cmd

Is This Answer Correct ?

1 Yes

3 No

Post New Answer