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
What are the Standard Reports and Forms in HRMS?
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.
Do you know where we can check the status of po?
In hierarchical structure of a database? we have write query from where we should start?
Can you define an erp system?
Are you familiar with internet architecture of oracle apps 11i?
Can u give the Documentation of Custom.pll in oracle apps
tell me the scenarios of the independent in reports
how can develope the po variance and po summary report? with tables mandatory columns and query please?
What do you understand by a set of books?
what are the prerequisites for costing transactions?
What is count(*) from po_vendors(any table)?
List of all the modules under Manufacturing, Finance and Distribution in oracle applications?
Hi, Anybody please send me the Oracle APPS 1i technical interview questions (Real time) as wel as sample resume also?
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