Answer Posted / chandu

Delete:
In delete statement we can use conditions
we can roll back
we can delete parent and child table rows also
it will activate in triggers
it can be slow compare to truncate.
Truncate:
In truncate statement we cant use conditons.
we cant roll back
we can delete child table rows only.
it will not activate in triggers.
it can be fast compare to delete.

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

2096

---

can u give guidance abt packages of plsql

2106

---

What is autocashrule set? : oracle accounts receivable

1292

---

Why more redos are generated when the oracle database is in begin backup mode?

1070

---

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

1726

---

i am pursuing mca and i want to do oracle apps technical in hydrabad, plz guide me tne best institue in hydrabad those have excellent knowledge in oracle apps.

2261

---

what are the API of GL,PO,AP

2215

---

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

2341

---

can we use lexical perameter in oracle plsql if yes how

2264

---

Difference between transaction type and transaction sources. : oracle accounts receivable

978

---

What is the technical flow associated with P2P or Procure to Pay cycle like the tables, APIs, concurrent programs involved in this cycle. Only technical please.

3865

---

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

2153

---

Explain how to account for bank charges deducted from amount received against an invoice. : oracle accounts receivable

1236

---

Hi, I want to know basic information about Oracle HRMS and the institutes in hyderabad or the best faculty as i want to make my career in it.And also want to know may a person from non technical background be able to do this course. Regards, Swetha

2461

---

Hi, IN oracle apps HRMS, if the employee changes his department, and when a conconurrent program is run for calulating the pay, The latest Dept id is not diaplayed, howeber the previous deptid is considered. Please can someone tell me where is the program going wrong, which side?

2803

---