Interested to Buy Any Domain ? << Click Here >> for more details...
Can you tell me the difference between DELETE & TRUNCATE
commands?
- 15 Answers
- 24561 Views
- I also Faced
- E-Mail Answers
Answer Posted / mohsin mohammed abdul
Delete command deletes the data from the tables .. but can
get back on issue of roll back whereas when you issue
truncate deletes the records and oracle implicitly issues
commit command and even when you issue rollback you won't
get the data back
| Is This Answer Correct ? | 10 Yes | 6 No |
Post New Answer View All Answers
What type of locking occurs during the snapshot generation? : sql server replication
What is difference between cte and view?
Explain transaction server consistency?
What is role playing dimension with two examples? : sql server analysis services, ssas
Do comments need to go in a special place in sql server 2005?
Do you know what is fill factor and pad index?
What is 1nf 2nf and 3nf?
What is the bookmark lookup and rid lookup?
How do you delete a trigger?
What are the main sources of data?
What is perspective, have you ever created perspective? : sql server analysis services, ssas
what are the new features in SSRS?
What is usually the first word in a sql query?
can an automatic recovery be initiated by a user? : Sql server administration
What are the differences between char and nchar in ms sql server?
