What is difference between truncate and delete ?

john125's Avatar
In oracle difference between turnacate and delete------
xpi0t0s's Avatar, Join Date: Aug 2004
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.
shabbir's Avatar, Join Date: Jul 2004
Go4Expert Founder
Check my reply in the following thread.

How do you differentiate between truncate and delete?