Answer Posted / dhanasekar.s

Truncate command executes faster then Delete command.
when you truncate the table we can't get back the data again
because data is removed from the memory.because ddl command
is auto commit.So we need not store any information about
deleted data in the memory.So it takes less time so faster.

But in the case of delete command is dml command.we can get
back(rollback) the data again.When you delete the data that
deleted data are stored in some where in memory that
information should be logged in the database log
information.From that information we can get the data again
easily.
So that (logging purpose) it takes time then truncate command.

It is my observation and my idea.If it is having any
mistakes please post the reason .

Thanks in Advance.

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

1236

---

1. What is PO rate variance gain and loss?

2835

---

What is the sql query to find the employee who has Nth maximum salary?

5216

---

i am working with OC 4.5 i have numbers in table in 10 row with some null values please tell me how to find total? Thanks

2207

---

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

2153

---

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

1063

---

Tell me about entire study of finacle software as soon as possible? give me the idea about questions which coulb be asked in interview of pnb it officers?

7910

---

What is an Oracle database Partial Backup?

1108

---

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

2539

---

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

2096

---

TILL WHAT LEVEL OF SECURITY BO SUPPORTS?

3482

---

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

---

What is db_recovery_file_dest in oracle? When do you need to set this value?

1075

---

What is mrc and what is its use? : oracle accounts receivable

1099

---

what are the API of GL,PO,AP

2215

---