Go4Expert - View Single Post - What is difference between truncate and delete ?

xpi0t0s

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.

xpi0t0s Mentor
16Mar2011,21:48
	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.