Hoe to skip middle of the record by using SQL*Loader?
- 5 Answers
- 12756 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 have 10 records. It's occured error in 6th record how can u find and how to rectify that?
What is Formula Column?
which is the table for storing organization information?
9 Answers Infosys, Scan Steel,
Tell me where we find the status of order information?
what is difference between procedure and function
why do we validate the records while developing interface?
what is the database size you used?
After deploying like forms,reports into server how we connect this forms,reports to web?
what is the purpose of standard cost update?
Can we customize a form with out template.fmb
Can 2 functions have same name & input parameters but differ only by return datatype ?
In one flat file i got headers and lines data how you can write control file now ?
Oracle Apps Technical 
