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
- 12671 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / naga bhushan
In Control file
At the top add this line.
(OPTIONS SKIP=30,LOAD=60)
| Is This Answer Correct ? | 10 Yes | 3 No |
Answer / 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 |
do you know is it possible to run the interface without using oracle apps?
what is mutating table and mutating error and how to solve that?
If we transfer the data from legacy system to oracle base tables. I want to hold the data in interface table how?
what are the error tables in OM
What repots or concurrent program run to transfer data from Inventory to GL.
what is the back ground program run while transferring data from OM to AR?
What are profile options?
What is ment by Global Templates in Oracle.
What is the use of format trigger?
differentiate between intra & inter UOM class conversion with examples.
In Per_all_people_f table what is the significance of '_f ' ?
What is the Exception. Types of exception, Difference between those. And example
Oracle Apps Technical 
