diff between DELETE and TRUNCATE?.
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
How to convert character types to numeric types?
Explain implicit cursor.
What is user managed backup in Oracle?
What is a snapshot log?
What are the advantages of oracle?
What happens if the update subquery returns multiple rows?
How to assign a table row to a record variable?
What is Undo Management Advisor in Oracle?
How to delete all rows a table in oracle?
How to best split csv strings in oracle 9i?
How do I call oracle stored procedures that take no parameters?
What is the quickest way to fetch the data from a table?
How do I find the database name in oracle?
Explain rename?
how to do daily transactions with out sql* loader control file regesterd in apps?