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 ?
- 2 Answers
- 11594 Views
- I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
What are do's and dont's of Interface?
Which oracle apps version you are very confident in?
What is instead of trigger in where we will use?
can we get profile values in report without using user exists is it possible how?
Plz anybody send me Technical specification for AP Interface
Can you differentiate between mediator and osb?
In oracle application how do you debug or trace errors?
How do you register report in oracle apps?
please any one provide the oracle erp technical interview questions on modules(PO,AP,AR,INV,GL,OM)wise to my mail id..narendra_609@yahoo.co.in
how do you describe O2C along with tables
If we have a repeated record in a table. But the repeated record how i can transfer from table to nested table?
What is sca and how is it useful?
WHAT IS CUSTOM VIEW AND CUSTOM COMPONENT?
CAN YOU CUSTOMISE THE COUTOMISE CUS_TOP
Do you know what is applysys in oracle application database schema, what is apps?
