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
- 12857 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 different components you should consider while defining a responsibility in oracle apps?
How many schemas we have? how many you have used?
How can we import the data into a database using sql * loader?
can we get profile values in report without using user exists is it possible how?
what is pay run id ?
What is oracle soa suite?
what is the difference between request group and request security in oracle apps?
Suppose for report I have to parameters those are from_date and to_date, so to_date should be greater when compare to from_date, if we are giving to_date is lessthen it must shows some error how we will make?
tell me the scenarios of the independent in reports
tell me the scenarios of the independent in reports
pls send me out bound code of supplers,site,bankiformation code pls as soon as
Hi any one plz help me .i need 2 or 3 customized and 2 or 3 development reports on PO module..if any body having plz send me with one by one step ,i mean where u do the customization and wht are the steps u follwed when u do the customization,wht are fields u added or deleted ,How u added or these fields as per clinet requirement and wht are errors u faced .plz send it to my mail id iamvenki@gmail.com
In sequence i want to 11 and 15th values how we will write?
How is choreography different from orchestration?
List the various types of value set.
