What is the difference between DELETE and TRUNCATE?
- 15 Answers
- 21931 Views
- Johns Hopkins University, Tech Mahindra, I also Faced
- E-Mail Answers
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
How do I run a sql script?
What is difference between inner join and cross join?
What is an exception in PL/SQL? What are the two types of exceptions?
What is sql*plus?
What are literals in sql server?
What are stored procedures used for?
Can pl sql procedure have a return statement?
How many types of keys are there in sql?
What is embedded sql in db2?
How do you concatenate in sql?
Can I learn sql in a week?
What is pl sql block structure?
Which join is like inner join?
Is primary key an index?
What is %rowtype in pl sql?
