Hoe to skip middle of the record by using SQL*Loader?
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 |
please any one provide the oracle erp technical interview questions on modules(PO,AP,AR,INV,GL,OM)wise to my mail id..narendra_609@yahoo.co.in
what is the difference between %_all and %_f tables
how can i print random rows in plsql table
wheather discard file is automatically created or explicty created?can u mention it?
The report output is 10 pages then how many times between pages report trigger will fire?
In custom.pll what are the events we can Not write.
How many typres of Purchase order and what are those.
what is aim methodolozy
What are ad-hoc reports?
What is the Lookup's and what is the use of lookup's?
how to get the on hand quantity of an item across all organizations? name the underlying tables.
2 Answers Ranves IT Solutions, Scan Steel,
what is flexfield qualifier?