Interested to Buy Any Domain ? << Click Here >> for more details...
diff between DELETE and TRUNCATE?.
- 14 Answers
- 22178 Views
- HCL, Yalamanchili Software, I also Faced
- E-Mail Answers
Answer Posted / pr@$@d
1 TRUNCATE is a DDL command whereas DELETE is a DML command.
2 TRUNCATE is much faster than DELETE.
Reason:
a) When you type DELETE. All the data get copied into
the Rollback Table space first. Then delete operation get
performed. That’s why when you type ROLLBACK after deleting
a table, you can get back the data (The system gets it for
you from the Rollback Table space).All this process takes
time. But when you type TRUNCATE, it removes data directly
without copying it into the Rollback Tablespace.Thatswhy
TRUNCATE is faster. Once you truncate you can’t get back
the data.
b) TRUNCATE command resets the High Water Mark for the
table but DELETE does not. So after TRUNCATE the
operations on table are much faster.
3 You can’t rollback in TRUNCATE but in DELETE you can
rollback. TRUNCATE removes the record permanently.
4 In case of TRUNCATE, Trigger doesn't get fired.But in DML
commands like DELETE .Trigger get fired.
5 You can’t use conditions (WHERE clause) in TRUNCATE.But
in DELETE you can write conditions using WHERE clause
Regards,
-Pr@$@d Reddi.
prasadreddi_mca@yahoo.com
| Is This Answer Correct ? | 6 Yes | 0 No |
Post New Answer View All Answers
What is tns entry?
When do you get a .pll extension in oracle? Explain its importance
Is it possible to center an object horizontally in a repeating frame that has a variable horizontal size ?
Why use resource manager in Oracle?
What is the oracle implicit cursor?
What is raw datatype?
What is the difference between truncate & delete command?
We are using Oracle apps with XML publisher.In that,we are facing some problems while giving a Footer in RTF Template.While giving a footer in RTF Template it is Visible in all the pages,but after the PDF is getiing generated,the Footer are Visible on alternate pages only (like on first page ,third page) and so on. Please provide the Solution for getting the Footer on all the pages.
What is the data pump import utility?
What is the difference between a user and a schema in oracle?
How to insert multiple rows with one insert statement in oracle?
How to create a stored procedure in oracle?
Explain temporal data types in oracle
What is connection pooling in oracle?
How to call a sub procedure?
