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

how can we add a field to the oracle standard forms through Form Persanlization or custom.pll

0 Answers   TCS,

---

what is diff between pre insert,on insert,post insert triggers?

1 Answers   IRISA,

---

What is autocashrule set? : oracle accounts receivable

0 Answers  

---

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

2 Answers   Ericsson,

---

as a technical developer in oracle applications which type errors feced in your experience sofar

0 Answers   HCL,

---

Give two methods you could use to determine what DDL changes have been made.

1 Answers  

---

Can you explain how to adjust the amount of advance already received against an invoice? : oracle accounts receivable

0 Answers  

---

Explain prerequisites and post activities of oracle database installation

0 Answers  

---

How would you force a log switch?

1 Answers  

---

What are different types of receipt reversals ? Explain them : oracle accounts receivable

0 Answers  

---

HOW TO SAVE UNIVERSES AND DOCUMENTS IN THE REPOSITORY?

0 Answers  

---

HOW SHALL WE DIFFERENTIATE BETWEEN PRIMARY KEY AND FORIEGN KEY?

4 Answers  

---