Answer / srinivas.r

We are having to two types the error records.....
1)Rejected by the SQL Loader.
These are stored in the '.BAD' file......
2)Rejected by the condition which have been mention in the
control file.
These are stored in the '.dis' file......

atfer getting the error records in the specified file then
we will correct the errors and proceed them once again...

Answer / roshan

if where clause doesn't satified the condition and flatfile
error, so we can refer discardfile.... and debug the errors

what is the difference between varchar and varchar(2)?

4 Answers  

---

I am insert in data to a table X .Which one is better while writing commit statement After each row inset or after all row insert to table.

3 Answers   IBM,

---

Can you have two stored functions with in the same name?

3 Answers  

---

how i can create temporary table?

1 Answers   Zensar,

---

What and Who is the best Institute or Trainer for Oracle Apps Technical ?

2 Answers  

---

Types of cursors?

3 Answers  

---

How to develop XML report without rdf?

4 Answers   Oracle,

---

How many schemas we have? how many you have used?

0 Answers  

---

what is the standard program for blanket po to process data from interface table to bace table

3 Answers   Zensar,

---

How many standard interface programs in oracle purchasing module and oracle inventory? What are they?

3 Answers   KPIT,

---

How to link modules in apps

3 Answers   Zensar,

---

what could be the problem if invoice_id is same in ap_invoices_all and ap_invoices_interface. while the Ord_id , invoice_num, and other things is diffrent .

3 Answers   Infosys, Oracle,

---