Answer Posted / dheeraj

Delete is DML Command ,Whereas Trucate is DDL command

Delete can be Rolled Back,Truncate cannot be rolled back,

Truncate is much faster then Delete

Delete will not released the memory space ,Memories would
be same if we use delete command the structure of the
table is still there

Trncate can be free the space in the meomory

Delete , use check constraints if exits then show error

Truncate don't use check constraint

difference of using cursor for loop and open,fetch,close.which one is better

1796

---

I need a Technical evaluation between Oracle and SAP ? please do a need ful.

1985

---

TILL WHAT LEVEL OF SECURITY BO SUPPORTS?

3569

---

Is there any link between pr form(purchse requisition)and po form(purchase order)

2710

---

what are the tools used for oracle 10g in real time.

2433

---

How would you determine who has added a row to a table?

2308

---

hi iam kavya, i completed Oracle11i(finance module), i do not know how to face the interview questions please adivese me

2226

---

Explain how to close periods in ar. : oracle accounts receivable

1304

---

please send me oracle pl/sql exp resume. and also faqs...

2486

---

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

1287

---

What is auto accounting what are the steps for setting up auto accounting? : oracle accounts receivable

1190

---

What is the Difference between the Person_Type_id column in the per_all_people_f and per_person_type_usages_f

4438

---

PURCHASE ORDER TO PAYABLES WHAT ENTREIS WILL HAVE

2210

---

What is the use of transaction flexfield in autoinvoice? : oracle accounts receivable

1143

---

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

2590

---