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
- 12846 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
Can we create tables in apps schema?
Tell me how to find the custom directory in front end?
What is the concept of soa governance?
How to create a purchase order without a requisition?
what are the prerequisites for costing transactions?
please send me forms, xml pulisher questions,answers
tell my any difficult situtation you solved in your experience in your company?
List the types of flexfield?
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.
Can you differentiate between mediator and osb?
what is the differences between internal requisition and internal sales order?
Tell me how to debug the report?
what are the different transaction clauses in AR?
how do you describe O2C along with tables
What are file in oracle.
