Answer Posted / raja lakshmi reddy v

hi friends this is raja

Truncate:
1. Truncate is used to delete all rows at a time, so the
table will become as free. The user feel the table does not
contain any rows, eventhough but internally the data exist
some memory that memory is free for our reuse.
2. Truncate is faster than delete, and where clause never
possible.
3. It is ddl command so that it will not roll back because
auto commit by default.
4. in sqlserver autoid columns will reset since from
starting seed value.
Delete:
1. Delete is used to Delete particular rows or all with
where clause or without where clause.
2. remeber if u delete rows, eventhough that memory will
never free means separate memory will allocate to our table.
3. It is slower than the truncate.
4. in sqlserver autoid values will never start from seed
intial value or default value.
5. while deleting check constrains, if any problem errow
thrown.

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

1157

---

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

1133

---

What is an Oracle database Full Backup?

1134

---

What is chargeback invoice? How do we create it? : oracle accounts receivable

1334

---

Explain accounting for invoice in advance and arrears. : oracle accounts receivable

1093

---

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

1223

---

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

2498

---

what are basic modules required to implement oracle application in any oraganisation?

2213

---

i want to know about the javaBean.what is its purpose and how it can use in Forms.

2466

---

Give two methods you could use to determine what DDL changes have been made.

6779

---

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

2604

---

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 payment term in ar. : oracle accounts receivable

1108

---

Are These Dff's Flexible?

1177

---

Differentiate between writeoff and receipt writeoff. : oracle accounts receivable

1349

---