Interested to Buy Any Domain ? << Click Here >> for more details...
Hoe to skip middle of the record by using SQL*Loader?
- 5 Answers
- 14262 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 |
How to link between inventory and OrderManagement.
Can u define operating units inplace of inventory?
tell me the scenarios of the independent in reports
what is the use of placeholer column?
In which directory your flatfile is given?if u connected different instance where it is find?
which is the table for storing organization information?
9 Answers Infosys, Scan Steel,
How many phases of implementation and what are those.
what is latest version in reports
Do you know what are user profiles in apps. Any examples you can give?
Stored procedure?
In support project one ticket alloted which steps follows manualy tell me ?
What multi org tables . example - difference between app table non all table . Po_header and po_headers_all
Oracle Apps Technical 
