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 ?
Answer Posted / naga bhushan
In Control file
At the top add this line.
(OPTIONS SKIP=30,LOAD=60)
| Is This Answer Correct ? | 10 Yes | 3 No |
Post New Answer View All Answers
Hi Friends this is preetham, i am searching for job on oracle apps(technical) i put 3 years fake exp, so any one please could you help me for realtime interview questions and 9739782164 this is my no srpsrp777@gmail.Com please guys please provide your no for contact i have a doubts i want to clarify
What is the concept of soa governance?
what is pay run id ?
Pls tel me the best text book for Oracle Apps 11i Tech? & I want D2K Text book also?
Do you know what is applysys in oracle application database schema, what is apps?
what is the differences between internal requisition and internal sales order?
How do you register report in oracle apps?
How many schemas we have? how many you have used?
WHAT IS CUSTOM VIEW AND CUSTOM COMPONENT?
In support project one ticket alloted which steps follows manualy tell me ?
How to create a purchase order without a requisition?
What is instead of trigger in where we will use?
Can u give the Documentation of Custom.pll in oracle apps
pls send me out bound code of supplers,site,bankiformation code pls as soon as
What do you understand by soa and what are the benefits of using this architecture?