Answer / amit

In Truncate only data are remove from table
where as in delete structure of table are delete.

Answer / rams

TRUNCATE:
1. it is a DML command.
2. by using truncate we can remove data in a table
permanantly.
3. we cant roll back the data.
4. it is faster than delete command.

DELETE:
1. it is a DDL command
2. by using delete command we can remove data in a table,
but we can rollback the data.
4. it is slower than the truncate command.

Answer / praveena

Truncate is the ddl command we can't get back, the delete
command we can delete the table not the fields.
In the turncate we can not get fields also these the main
differance.,
i think so

What is the Query Optimizer. How you optimize your qeury.

2 Answers   Ericsson,

---

What are the main diff. between oracle 7.3 and oracle 8i?

1 Answers  

---

What is the use of lockboxes? Steps for lock box : oracle accounts receivable

0 Answers  

---

what are all the conversion and interfaces in GL,AP,AR,HRMS with example? otherwise send send link for these

0 Answers   Pathway Technologies,

---

which gives Oracle R12 Financial training in delhi please give me answer its urgent?

0 Answers  

---

i want to know about the javaBean.what is its purpose and how it can use in Forms.

0 Answers   Logisoft,

---

CAN AUNIVERSE BE LINKED TO MORE THAN ONE DATASOURCE?

0 Answers  

---

What is database schema?

4 Answers   Infosys,

---

3. Steps in UAT?

0 Answers   Oracle,

---

key flexfield structure

0 Answers   Infosys,

---

what is shared memory?

1 Answers   IBM,

---

HOW SHALL WE DIFFERENTIATE BETWEEN PRIMARY KEY AND FORIEGN KEY?

4 Answers  

---