Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
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 ?

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


Please Help Members By Posting Answers For Below Questions

What are the Standard Reports and Forms in HRMS?

2321


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.

3037


Do you know where we can check the status of po?

1293


In hierarchical structure of a database? we have write query from where we should start?

2253


Can you define an erp system?

1149


Are you familiar with internet architecture of oracle apps 11i?

1070


Can u give the Documentation of Custom.pll in oracle apps

3484


tell me the scenarios of the independent in reports

2518


how can develope the po variance and po summary report? with tables mandatory columns and query please?

2395


What do you understand by a set of books?

1118


what are the prerequisites for costing transactions?

3145


What is count(*) from po_vendors(any table)?

1090


List of all the modules under Manufacturing, Finance and Distribution in oracle applications?

2223


Hi, Anybody please send me the Oracle APPS 1i technical interview questions (Real time) as wel as sample resume also?

2619


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

3666