Answer Posted / vijay rana

1.truncate is a DML command but Delete is a DDL Command

2.truncate is much faster then Delete

3.we can rollback delete but we cant rollback Truncate

4.we can not use where in truncate but we can use where with
delete

5.in case of truncate memory released immediately, but in
case of delete memory dosen release if we dont press commit.

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

2078

---

What are the advantages of operating a database in ARCHIVELOG mode over operating it in NO ARCHIVELOG mode in Oracle?

1169

---

what is difference between inner join & nested query or subqueries

3045

---

I am Bsc Computer Science Graduate, I have good knowledge in SQL 7.0, Can I go for Oracle APPS course please suggest me the answer

2266

---

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

2072

---

Explain the process of recievables in oracle financials. : oracle accounts receivable

1157

---

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

2075

---

where the dff data will be stored

2450

---

HOW TO SPOT AHIERARCHY?

2300

---

What Are Cross Validation & Adi?

1162

---

What do you mean by hz_ in customer tables? : oracle accounts receivable

1224

---

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?

1352

---

My requirement is like in database some defects are present and i need to clean them.To be brief for example every employee should have active assigments.So for those records which are not having status as active or null ,i need to update the roecords using API with the correct value. Client will provide a flat file for the records whch are defected.So i need to run the API for those records (flat file)and update the data in database. So my question is how to handle this requirement.Is there any existing API for this purpose?If yes then please send me the NAME. How to update the records in the database using flatfile. Any pointer will be appreciated.Thanks in advance.

2203

---

How many segment are present in Oracle Manufacturing

2320

---

can u give guidance abt packages of plsql

2176

---