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

Hi  Friends this is preetham, i am  searching for job on oracle apps(technical) i put 3 years fake exp, so any one  please could you help me for realtime interview  questions and 9739782164 this is my no srpsrp777@gmail.Com please guys please provide your no for contact i have a doubts i want to clarify

2006


What is the concept of soa governance?

1217


what is pay run id ?

2127


Pls tel me the best text book for Oracle Apps 11i Tech? & I want D2K Text book also?

2070


Do you know what is applysys in oracle application database schema, what is apps?

1135


what is the differences between internal requisition and internal sales order?

2603


How do you register report in oracle apps?

1029


How many schemas we have? how many you have used?

2002


WHAT IS CUSTOM VIEW AND CUSTOM COMPONENT?

3004


In support project one ticket alloted which steps follows manualy tell me ?

2611


How to create a purchase order without a requisition?

1121


What is instead of trigger in where we will use?

1124


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

3419


pls send me out bound code of supplers,site,bankiformation code pls as soon as

2209


What do you understand by soa and what are the benefits of using this architecture?

1025