What is difference between TRUNCATE & DELETE ?

Question

Hello
What is difference between TRUNCATE & DELETE in oracle?
please reply me. i am waiting for your reply.
Thanx

Comments

<a href="http://www.discountu99boots.com/ugg-bailey-button-c-12">ugg bailey button</a>
<a href="http://www.discountu99boots.com/ugg-tall-metallic-c-7">ugg tall metallic</a>
<a href="http://www.discountu99boots.com/ugg-knightsbridge-c-19">ugg knightsbridge</a>
<a href="http://www.discountu99boots.com/ugg-rainier-c-22">ugg rainier</a>
<a href="http://www.discountu99boots.com/ugg-mayfaire-c-20">ugg mayfaire</a>I had a great time around the fire and the food was great too. glad I could contribute to your tips #9.   . your the best. see you next time

Answer 1

TRUNCATE commits after deleting entire table i.e., can not be rolled back. Database triggers do not fire on TRUNCATEDELETE allows the filtered deletion. Deleted records can be rolled back or committed.Database triggers fire on DELETE