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
Explian rowid, rownum? What are the psoducolumns we have?
How do I turn a list into a table?
How to run sql statements through the web interface?
Can we use loop in sql?
Why is the cursor important?
What is relationship? How many types of relationship are there?
Explain the the update statement in sql?
Describe sql comments?
Does pdo prevent sql injection?
Can we rename a column in the output of sql query?
Explain lock escalation? : Transact sql
How do I run a pl sql program?
how to include numeric values in sql statements? : Sql dba
How to disable a trigger name update_salary?
How can you load microsoft excel data into oracle? : aql loader