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

What is supporting issues GL AP and AR?

2480

---

WHAT ARE TEMPLATES?EXPLAIN WHAT YOU HAVE CREATED?

1977

---

What is an Oracle database Full Backup?

1091

---

types of receipts and detail desription about recipts and tables effected by receipts?

2030

---

WHAT ALL DIFFERENT OPTIONS PRESENT IN WEBI?

2893

---

key flexfield structure

2123

---

now iam working as an hr executive in hyderabad i would like to learn oracle hrms kindly suggest me some good institutes in hyderabd

2252

---

Where in the Oracle directory tree structure are audit traces placed?

2585

---

1)After defining value set we define list of values, I need to enter 1000 values with out entering manually, how will you do that? 2)what are the parameters we use in a concurrent program? 3)what is payroll processing? 4)In organization window after defining an organization and organization classification how to create a new item in the others button? 5)If there are 10 users, How to restrict the selected users not to access the forms?

2133

---

how to write customizations in po

1573

---

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

2556

---

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

1967

---

what are all the conversion and interfaces in GL,AP,AR,HRMS with example? otherwise send send link for these

2281

---

I've got a database 10g and Form version 5.0 but unable to connect. Does Oracle 10g database supports form 4.5

2478

---

How many segment are present in Oracle Manufacturing

2274

---