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
- 12962 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 is count(*) from po_vendors(any table)?
What is a flexfield? List out its types.
where to define interorganization transaction charges and what are the different options?
In sequence i want to 11 and 15th values how we will write?
Do you know where we can check the status of po?
What do you understand by soa?
Can u give the Documentation of Custom.pll in oracle apps
WHAT IS CUSTOM VIEW AND CUSTOM COMPONENT?
What are do's and dont's of Interface?
Tell me how to find the custom directory in front end?
Explain what are the tables of auto invoice?
how can i print random rows in plsql table
How do you register report in oracle apps?
what is global tempory table?
what is pay run id ?
