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 about party and customer in ar : oracle accounts receivable

1211

---

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

2727

---

what is difference between inner join & nested query or subqueries

3036

---

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

1233

---

I would like to study certification course in Data base adminidtrator then where would i go to study this course?

2190

---

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

2070

---

How would you determine what sessions are connected and what resources they are waiting for?

2127

---

Differentiate between standard remittance and bills receivable remittance : oracle accounts receivable

1145

---

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

2280

---

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

2494

---

How many segment are present in Oracle Manufacturing

2320

---

What is auto invoicing? Explain : oracle accounts receivable

1126

---

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

2601

---

What are the different tools available for hot backups in Oracle? Is it preferable to take it manually all the time or it depends on the size of the database?

1349

---

Difference between negative and positive adjustments : oracle accounts receivable

1104

---