diff between DELETE and TRUNCATE?.
- 14 Answers
- 18216 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
How to empty your oracle recycle bin?
6. Display the client name and order date for all orders using the traditional method.
What are the oracle differences between nvl and coalesce
How to sort output in descending order in oracle?
What is meant by an index?
What is a read write transaction in oracle?
What is a server parameter file in oracle?
How to drop an existing view in oracle?
How to store only time; not date and time?
Hi this srilatha. I comlpeted my Oracle-hrms. can u provide me interview questions on Core hr, payroll,sshr,OLM etc..
Explain the use of indexes option in imp command.
What is the dynamic sql in oracle?
How to create additional tablespaces for an new database?
How does propagation differ between Advanced Replication and Snapshot Replication (read-only)?
What is meant by joins? List out the types of joins.
