Hoe to skip middle of the record by using SQL*Loader?
- 5 Answers
- 12324 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / veluruga
By using FILLER Command, it will not accept the data and it inserts the NULL values.
Ex:
(Empno,
Ename,
Date FILLER);
| Is This Answer Correct ? | 8 Yes | 4 No |
Answer / kutti
FILLER is used to skip the entire column not particular set of data .
| Is This Answer Correct ? | 3 Yes | 0 No |
Answer / nuthan
At cmd prompt
Sqlldr user/pwd@inst
Control= d:/filename.ctl load 10 skip 1
| Is This Answer Correct ? | 0 Yes | 0 No |
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.
| Is This Answer Correct ? | 2 Yes | 3 No |
we are inserting,update and delete the data we can do simultaniously, but it will show error in updation? what to do?
difference between 2 way and 4 way matching
CAN YOU CUSTOMISE THE COUTOMISE CUS_TOP
in interface and conversion if 10 records are error out we can't load the records?if >10 we have to insert,if we not insert we need to gernerate error how u can achieve?
what is the differences between internal requisition and internal sales order?
What are the files we submit while your program move to testing instance?
In unix Schell sript what is very 1st line to be wriiten .
What is the concept of soa governance?
In developer Reports::there are 3 parameters.can you pass the paramter1+paratmeter2 value to the third parameter??
After completing Report customization process.suppose we have 10 report parameter in report so, that we re-register that parameter in concurrent program?
Can u define DFF with in the DFF,How?
what are the difference between oracle discoverer and report6i
Oracle Apps Technical 
