Interested to Buy Any Domain ? << Click Here >> for more details...
diff between DELETE and TRUNCATE?.
- 14 Answers
- 22625 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 oracle sid?
How to use "while" statements in oracle?
How would you configure your networking files to connect to a database by the name of DSS which resides in domain icallinc.com?
What is the difference between view and materialized view in Oracle?
Can we write insert statement in function in oracle?
How to start a new transaction in oracle?
What are the differences between interval year to month and interval day to second?
What is a table in oracle?
What are transaction isolation levels supported by oracle?
What is the string concatenation operator in oracle?
What are the four Oracle system processes that must always be up and running for the database to be useable?
Explain the use of rows option in imp command.
Compare and contrast between sql and sql server and explain its various functions?
What is meant by raw datatype?
How to define an anonymous block?
