What is difference between truncate and delete ?
 

In oracle difference between turnacate and delete------

Re: What is difference between turnacate and delete ?
 

see Page 19-67 of the 11.2 SQL Language Reference (or just search for TRUNCATE TABLE in whatever version of the SQL Language Reference you have handy).

Also you might try Googling for "oracle difference truncate delete" which might return a few hits.

Re: What is difference between truncate and delete ?
 

Check my reply in the following thread.

How do you differentiate between truncate and delete?