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
- 12677 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 |
what is the difference between oracle applications ebs 11.5.9 and 11.5.10.2 and can anyone suggest the release dates of the versions
define steps of assigning items to an organization.
what are the different transaction clauses in AR?
why do we go for oracle apps technical other than sap and other packages?
how can develope the po variance and po summary report? with tables mandatory columns and query please?
maximum how many parameters we can pass through pl/sql stored procedure to oracle apps?how many mandatory parameters we can pass through pl/sql program to oracle apps11i?
what is the need of registering table in apps?
we have 10 records. It's occured error in 6th record how can u find and how to rectify that?
FLEX FIELDS?
Steps for DFF registration
List some exceptions other than NO_DATA_FOUND, TOO_MANY_ROWS and WHEN OTHERS
What is the concept of soa governance?
Oracle Apps Technical 
