Interested to Buy Any Domain ? << Click Here >> for more details...
What is the difference between DELETE and TRUNCATE?
- 15 Answers
- 25142 Views
- Johns Hopkins University, Tech Mahindra, I also Faced
- E-Mail Answers
Answer Posted / debi
1.when we use delete command then the records from the
table is not deleted permanently so that when we further
use rollback command the records are again available in the
table but in case of truncate the data is permenently
deleted from the table.
2.in case of truncate data deletion is faster as compared
to delete
3.
we can't use ant where condition in case if truncate
| Is This Answer Correct ? | 2 Yes | 2 No |
Post New Answer View All Answers
How can I speed up sql query?
What is nosql db?
How to look at the current sql*plus system settings?
What is a system versioned table?
Is sql better than excel?
How do I view stored procedures?
How many types of cursors are available in pl/sql?
Is sql easier than java?
how many triggers are allowed in mysql table? : Sql dba
What is package in pl sql?
Does oracle roll back the transaction on an error?
How many tables can a sql database have?
Can unique keys be null?
Why functions are used in sql?
How do you remove duplicates without using distinct in sql?
