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
- 12801 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 do you describe O2C along with tables
what is pay run id ?
What is instead of trigger in where we will use?
is it possible to run the interface without using oracle apps?
Plz anybody send me Technical specification for AP Interface
How to create a purchase order without a requisition?
Explain what are the tables of auto invoice?
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
What is a value set? List its various types.
Tell me where we find the status of order information?
In oracle application how do you debug or trace errors?
Explain oracle apps architecture.
How many schemas we have? how many you have used?
Which oracle apps version you are very confident in?
What do you understand by soa and what are the benefits of using this architecture?
