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
- 12664 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 the benefits of using soa architecture?
what is global tempory table?
What do you understand by concurrent programs?
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.
how to print multi lay outs,muti currency,muti language in xml publisher
Explain what are the tables of auto invoice?
What do you understand by a set of books?
Can we create tables in apps schema?
Pls tel me the best text book for Oracle Apps 11i Tech? & I want D2K Text book also?
What is oracle soa suite and what are its different components?
Which oracle apps version you are very confident in?
Tell me how to find the custom directory in front end?
How can you achieve loose coupling in soa framework?
Do you know where we can check the status of po?
is it possible to run the interface without using oracle apps?
