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
- 12718 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
How many schemas we have? how many you have used?
What are do's and dont's of Interface?
What do you understand by concurrent programs?
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?
how to print multi lay outs,muti currency,muti language in xml publisher
Plz anybody send me Technical specification for AP Interface
can we use look up type instead of a pofile option?or valueset?is it possible how?
Explain oracle apps architecture.
tell me the scenarios of the independent in reports
what is pay run id ?
Explain what are the tables of auto invoice?
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
List the types of flexfield?
How can you achieve loose coupling in soa framework?
how do you describe O2C along with tables
