Answer Posted / vijay rana

1.truncate is a DML command but Delete is a DDL Command

2.truncate is much faster then Delete

3.we can rollback delete but we cant rollback Truncate

4.we can not use where in truncate but we can use where with
delete

5.in case of truncate memory released immediately, but in
case of delete memory dosen release if we dont press commit.

IS IT POSSIBLE TO CREATE REPORTS FROM DIFFERENT UNIVERSES IN ONE DOCUMENT?

2252

---

What is the difference between conversions and interfaces? : oracle accounts receivable

1200

---

3. Steps in UAT?

2428

---

while creating requisitions i am unable to see the list of organisation can anyone help me out ?

2131

---

Explain the process of recievables in oracle financials. : oracle accounts receivable

1151

---

Difference between negative and positive adjustments : oracle accounts receivable

1091

---

How would you go about increasing the buffer cache hit ratio?

2591

---

What are different types of transactions in ar? : oracle accounts receivable

1281

---

Differentiate between unidentified receipt, unapplied receipts and on account receipts? : oracle accounts receivable

1767

---

how to write customizations in po

1608

---

What is the importance of batch source set up in ar? : oracle accounts receivable

1253

---

default triggers available for reports

2204

---

what are the interface and api table for receipts conversion in oracle receivables? : oracle accounts receivable

1122

---

what is the link between suppliers and banks in ap module in oracle apps? And also query?

2465

---

1.In a table Gender is a column in that male and female are the two data.In a single statement i have to modify all male to female and all female to male vice versa. 2.In a single query i need the count of male data,count of female and total count

17622

---