in sql loader,i have 100 records in my flatefile, i want to
skip the 80 to 90 records .please help me
Answers were Sorted based on User's Feedback
Answer / naresh kotapati
by using filler option we can omitt the records
| Is This Answer Correct ? | 13 Yes | 3 No |
Answer / venki
By using "Filler" Command
OR
By Usins "When" Condition
| Is This Answer Correct ? | 7 Yes | 5 No |
Answer / vinay thakur
We can not skip in btw records like 80-90
We can skip starting records and load remaining records..
| Is This Answer Correct ? | 3 Yes | 1 No |
Answer / balaji
options(skip=80,load=10)
load data
-------
-------
| Is This Answer Correct ? | 8 Yes | 10 No |
sourcing in GL
HOW MANY LANGUAGES FOLDERS ARE ONE ORACLE APPLICATION
How You Will display the key flexifields in your report
difference between 2 way and 4 way matching
How we will receive the work from the client? what type of documents we will develop in the entire implementation project? plz tell me the total scinario?
2 Answers Deloitte, Intelligroup,
can we pass bind variablein lexical parameter?
What are the User PARAMETERS in the Reports?
What is instead of trigger in where we will use?
what is the prerequisite for defining unit of measure?
in one report using two layout models.if yes how to do
which parameters passed in report in oracle developer how to pass
what do you mean by value sets