What is the difference between DELETE and TRUNCATE?
- 15 Answers
- 20355 Views
- Johns Hopkins University, Tech Mahindra, I also Faced
- E-Mail Answers
Answer Posted / kalyana chakravarthy
Delete is associated with rollback segments like U can undo
it before committing and U have a choice of deleting a
specific row or rows where as
Truncate is not associated with rollback segments ie U cant
undo it and U cant delete a row/rows of ur choice
| Is This Answer Correct ? | 6 Yes | 1 No |
Post New Answer View All Answers
What are dml commands?
Hi am new to PLSQL & facing problems in writing code like in SP, Functions, so any one having some SP coding with in depth explanation please share with me my Email ID suvarnaatsuvarna@rediffmail.com Or taking tanning on this please do contact me
Can we insert in sql function?
What is auto increment in sql?
Do we need to rebuild index after truncate?
what are set operators in sql? : Sql dba
What is clause?
What are the topics in pl sql?
What is a sql statement?
What does trigger mean in psychology?
Which is better stored procedure or query?
What is database migration?
Which data dictionary views have the information on the triggers that are available in the database?
Which one is faster ienumerable or iqueryable?
Can primary key be changed?
