In SQL Loader i have 100 Records to be loaded into my table.
How do i load the first 30 Records and skip the last 10
Records within a single .ctl file ?
So my total no.of records to be loaded would be 60.
Could anybody help me in this ?
Answers were Sorted based on User's Feedback
Answer / naga bhushan
In Control file
At the top add this line.
(OPTIONS SKIP=30,LOAD=60)
Is This Answer Correct ? | 10 Yes | 3 No |
Answer / kumar
In Control file
At the top add this line.
(OPTIONS SKIP=30 RECORDS=60)
skip option skips first 30 records
Records option load 60 records
Automatically last 10 Records will not be considered by SQL
Loader.
Is This Answer Correct ? | 1 Yes | 3 No |
AOL?
Tell me some interface tables on ordermangement.
Please let me know the differance between Master Item and organization Item in Inventory.
What is MO operating units. Why it need to to set this and where .
what is the database size you used?
Is SOB is attached with Business grp ?
If we have a repeated record in a table. But the repeated record how i can transfer from table to nested table?
what is organization id
what r the objects u have to do in u experiance
what is the back ground program run while transferring data from OM to AR?
what is the difference between request group and request security group in oracle apps?
What is profile and what is level of profile option and it's hierarchy