Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 12845 Views
- I also Faced
- E-Mail Answers
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
How do you register report in oracle apps?
In sequence i want to 11 and 15th values how we will write?
What do you understand by soa?
Can you define an erp system?
In which tables receopt application form Appliy to field Value will come. I know one table i.e, ra_customer_trx.trx_number. Could U please any one tell me other than this except(ra_customer_trx and ar_payment_schedules_all tables). plz mentioned tables_name.Column_name.
Tell me where we find the status of order information?
what is global tempory table?
how can i print random rows in plsql table
Do you know what are user profiles in apps. Any examples you can give?
What is oracle soa suite and what are its different components?
testing tools?
In support project one ticket alloted which steps follows manualy tell me ?
Are you familiar with internet architecture of oracle apps 11i?
what are the different transaction clauses in AR?
do you know is it possible to run the interface without using oracle apps?
