Delete - temparaly delete the table we can undo it using rollback where

What is Difference Between delete and Truncate?

Question Posted / muralipitti

Answer Posted / muralipitti

Delete - temparaly delete the table we can undo it using
rollback where as

truncate= delete+commit we can't rollback it .

Is This Answer Correct ?

4 Yes

0 No

Please Help Members By Posting Answers For Below Questions

How do I install microsoft sql?

1050

What is sql*loader and what is it used for?

1153

How to load data with sql*loader?

1048

what are the differences between char and nchar? : Sql dba

1115

What is a primary key example?

956

What are different types of triggers?

1110

what is try_catch block in procedure

1748

What is the best free sql database?

1051

what is 'mysqld'? : Sql dba

969

What is latest version of sql?

1044

Who is the owner of mysql database?

1057

What is string join?

977

Can two tables have same primary key?

976

Why do we create views in sql?

1151

What is nvl?

1065