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
- 12804 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 |
How to make Parameter as Mandatory?
What is the result of this query ? SELECT * FROM EMP WHERE ROWNUM = 1
can we write sql statement in Format trigger?
I want to print output in portrait style?where i have to change the settings?
why r u move in the cus_top only why not move another top
What is profile and what is level of profile option and it's hierarchy
what is the difference between character mode,bitmap mode
2 Answers IBM, Sierra Atlantica,
What is Summary columns?
what is lexical parameter?
when will formula,place holder and summary columns fire in reports?
Are there any alternate tools other than sql* loader to load data into oracle apps tables from external systems
sourcing in GL
Oracle Apps Technical 
