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.

What is the mandatory setup in cyclecount ?

2744

---

PURCHASE ORDER TO PAYABLES WHAT ENTREIS WILL HAVE

2210

---

What is Tax Categories?

2104

---

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

1280

---

how to replace not in with not exist?

3724

---

Can we modify approve purchase order?if yes what is navigation?

2002

---

QUESTION IS THAT DURING UPLOADING DATA IN PROD SERVER,OUR EQUIPMENT TAG NUMBERS ARE NOT MATCHING WITH SAP TAG NUMBERS SO DUE TO THIS WE ARE FACING PROB, BECAUSE WHENEVER ALARM IS COMING FROM SCADA DUE MISMATCH THE NOTIFICATION IS NOT CREATED IT IS GIVING ERROR. PLEASE SUGGEST THE METHOD SO THAT THE TAG NUMBERS OF BOTH (SCADA EQUIPMENT AND SAP EQUIP) SHOULD CONCIDE.OTHERWISE WE HAVE TO GO FOR LONG PROCESS EITHER BY INTERFACE TABLE OR BY EXPORTING ALL DATA AND MAKING RIGHT CHANGES.DO YOU HAVE ANY SHORTCT METHOD PL WRITE ME. THANKS

2061

---

key flexfield structure

2166

---

HOW TO SAVE UNIVERSES AND DOCUMENTS IN THE REPOSITORY?

2054

---

What is an Oracle database Partial Backup?

1149

---

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

1199

---

if i write the procedure.. and other person make the changes in that code then where i find who is changing my procedure

2061

---

Explain accounting for invoice in advance and arrears. : oracle accounts receivable

1083

---

CAN AUNIVERSE BE LINKED TO MORE THAN ONE DATASOURCE?

2063

---

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

2391

---