Interested to Buy Any Domain ? << Click Here >> for more details...
Can you tell me the difference between DELETE & TRUNCATE
commands?
- 15 Answers
- 24471 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 is the distinction amongst delete and truncate?
What is a synonym for manipulation?
Explain indexing and what are the advantages of it?
What is 2nf example?
What are the steps to take to improve performance of a poor performing query? : sql server database administration
Give me a SQL Query to find out the second largest company?
What are synonyms?
What are xml indexes?
What is the difference between implicit and explicit transaction?
How can you manage sql azure security?
How do I find the transaction log size in sql server?
Can a function call a stored procedure in sql server?
What do you understand by sql server agent?
What is sparse columns of sql server 2008?
Can you create a logon trigger in sql server 2005 express edition?
