Answer / veluruga

By using FILLER Command, it will not accept the data and it inserts the NULL values.

Ex:
(Empno,
Ename,
Date FILLER);

Answer / kutti

FILLER is used to skip the entire column not particular set of data .

Answer / nuthan

At cmd prompt
Sqlldr user/pwd@inst
Control= d:/filename.ctl load 10 skip 1

Answer / sree

1. Use When Clause to load selective records to base tables.
2. Unwanted records get skipped and placed in warning files.
3. If you want skip warning then load unwanted records to temporary tables and then delete them.

Answer / krishna

(empno,
ename,
sal filler)

can we write multiple procedures in package with same name like A p1,p2(parameters) B p1,p2(same parameters)

4 Answers  

What is secuirity's in R12 features.

1 Answers   KPIT,

wht is difference between is and as varibales,while declaring procedure which is better?

3 Answers   Wipro,

How can u populate data into po_headers_all segment2 column?

1 Answers   BirlaSoft,

Do you know where we can check the status of po?

0 Answers  

in one report using two layout models.if yes how to do

4 Answers   Covansys,

Which is the best website to learn Oracle Apps?

2 Answers  

What is set function in sql .E.g.What is difference between union and union all

2 Answers   IBM, TCS,

Difference between Bind and Lexical parameters?

3 Answers  

Please let me know the differance between Master Item and organization Item in Inventory.

5 Answers   Wipro,

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,

we have 10 records. It's occured error in 6th record how can u find and how to rectify that?

2 Answers