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 |
Can you define an erp system?
Can u suggest me the best institute for Oracle apps Technical in Hyderabad?
please send me forms, xml pulisher questions,answers
What is menu.
can we write sql statement in Format trigger?
What are triggers?
Do you know where we can check the status of po?
How to report output like below supplier name date amount abc software jan/11 10000 /* jan month total transactions*/ abc software feb/12 30000 /* feb month total transactions*/ dell computers jan/13 45000 /* jan month total transactions*/
What is the link between AP and GL in oracle apps R/12?
4 Answers Bosch, Collabera, Synechron,
List the various types of value set.
Form development process?
what is the back ground program run while transferring data from OM to AR?