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)

While importing data into interface tables,if u got number of records are error(like more than 1000 records are error),how to imform user?

2 Answers  

differentiate between intra & inter UOM class conversion with examples.

1 Answers   Scan Steel,

We have to show a logo/image in a report? what are the steps and which format it is?whether in pdf format is applicable or not?

3 Answers   IBM,

types of invoices?

7 Answers   BelAir Store, Convergys, Wings Biotech,

What is implicity cursor . When it fires . For which statement it will fire(Insert/update/delte). What is the attribute of implicity and explicity cursor oracle 9i. What is the Rec cursor.

2 Answers   IBM,

Can you explain the difference between architecture followed in 10g & 11g?

0 Answers  

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

5 Answers   Wipro,

How can u populate data into po_headers_all segment2 column?

1 Answers   BirlaSoft,

q)what are the validations in sql*loader

0 Answers   Accenture,

hi gurus my name is ramesh i was completed orcale apps technical trainning i wnt to put 3+yrs experience is it correct r not ,if any freshers jobs are available in market pls suggest me. my mail id rameshmcaou@gmail.com and contact no is 9000342411

3 Answers   Oracle,

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

2 Answers  

How will you get the concurrent program output as email?

3 Answers   IBM, KPIT,