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 |
What is the concept of soa governance?
How to create a purchase order without a requisition?
I want to develop a oracle applications report using report builder 6i. I have two user parameters. How to provide list of values to parameters, which should show me at the time of submitting concurrent program.
1 Answers Genpact, Y3K Imaginations,
in which tables the transaction details stored? at least two.
Tell me where we find the status of order information?
where u do setup of operating unit?
what are the pl/sql tables
can we pass bind variablein lexical parameter?
in one report using two layout models.if yes how to do
Which modules of oracle apps have forms and reports? I am a beginner in oracle apps so kindly answer my query.
Matrix Report: Simple, Group above, Nested
What are the Major differences bteween key flexfields ,descriptive flexfields
4 Answers Sierra Atlantica, TechBulls,