Interested to Buy Any Domain ? << Click Here >> for more details...
diff between DELETE and TRUNCATE?.
- 14 Answers
- 22158 Views
- HCL, Yalamanchili Software, I also Faced
- E-Mail Answers
Answer Posted / kumar
DELETE TABLE is a logged operation, so the deletion of each
row gets logged in the transaction log, which makes it
slow.
TRUNCATE TABLE also deletes all the rows in a table, but it
won't log the deletion of each row, instead it logs the
deallocation of the data pages of the table, which makes it
faster.
The records deleted through DELETE can be roll backed.
The records deleted through TRUNCATE can't be roll back.
If we are using TRUNCATE ina Transaction then only we can
do the roll back else not.
Both will delete the data but not the stucture of the table.
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
What is proxy method?
How to get last row id?
State all possible different index configurations a table can possibly have?
How to drop a tablespace?
What is an external table?
Does oracle charge for java?
If a parameter is used in a query without being previously defined, what diff. exist betw. report 2.0 and 2.5 when the query is applied ?
Can we convert a date to char in oracle and if so, what would be the syntax?
How to sort the query output in oracle?
How do I manually create a database in oracle?
State some uses of redo log files?
How to declare a local variable?
Is oracle a language?
What is the usage of synonyms?
In Oracle Clinical 4.5.0, can the VIEW_TEMPLATE_ID column in DATA_EXTRACT_VIEWS table contain NULL value?
