What is the difference between DELETE and TRUNCATE?
Answer Posted / althaf
the delete command log all the stmts in the transaction log
and the truncate command dont log the stmts.
| Is This Answer Correct ? | 8 Yes | 2 No |
Post New Answer View All Answers
What is rownum?
What is the difference between microsoft sql and mysql?
What is union, minus and interact commands?
Why is there a need for sqlcode and sqlerrm variables?
What is the syntax to add a record to a table?
Explain what is an index?
what is the difference difference between procedure and packages
How subquery works in sql?
What are the commands used in sql?
How is pl sql different from sql?
tell me about various levels of constraint. : Sql dba
What does (*) mean in sql?
What is sql clause?
When to use inner join and left join?
What are the different dcl commands in sql?