Go4Expert

Go4Expert (http://www.go4expert.com/)
-   Oracle (http://www.go4expert.com/forums/oracle-forum/)
-   -   What is difference between truncate and delete ? (http://www.go4expert.com/forums/difference-truncate-delete-t25252/)

john125 15Mar2011 11:42

What is difference between truncate and delete ?
 
In oracle difference between turnacate and delete------

xpi0t0s 16Mar2011 21:48

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.

shabbir 16Mar2011 22:21

Re: What is difference between truncate and delete ?
 
Check my reply in the following thread.

How do you differentiate between truncate and delete?


All times are GMT +5.5. The time now is 23:02.