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

What happens to the current transaction if the session is ended?

1033

---

Explain oracle instance.

1105

---

How many file formats are supported to export data?

1135

---

How to handle a single quote in oracle sql?

971

---

How to check your oracle database 10g xe installation?

924

---

How do I escape a reserved word in oracle?

1130

---

How to write an inner join with the where clause in oracle?

994

---

What is a named program unit?

1018

---

What is oracle rownum?

886

---

What is the difference between a hot backup and a cold backup in oracle?

957

---

What happens if the imported table already exists?

971

---

Why do you use stored procedures and state some of its disadvantages?

967

---

What is the difference between a primary key & a unique key?

1037

---

Why is oracle database so popular?

947

---

How to select some columns from a table in oracle?

1002

---