السلام عليكم ورحمة الله وبركاته،،

what are the deferences between truncate table instruction and delete from table,

what is the benefit of two commands do same thing , as i under stand . help me please

hello , the main difference between delete and truncate is that you can rollback the delete statment , but u can't rollback a truncate statment , which means you can retreive records which was delete , but you can't retreive records that are truncated .

مشكورييين على المعلومات القيمه

thank u 2 much khalidocp ,for answering me ,but what is the benefit of "truncate ",while "delete" doing same function and also can rollback its effect
!!!

when u delete a big data from table it is nice to use truncate with option drop storage to clear the space that the table use and it is the benifit of use truncate

Truncat is DDL statement and Delete is DML statement , this deference is enough to understand the benefits, because as we know DDL commits any transactions before it and also it works directly with the tablespace , this is my concept in addition to the previous answers of our brothers...

thank u all for answers,
and good view from brother OSS...thats right what u said.

another important thing is

when u use delete u do not take back the stoarge used by the table data the table size still the same.

but with truncate it reset the table size to its initial value.