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
- 12864 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 |
Which modules of oracle apps have forms and reports? I am a beginner in oracle apps so kindly answer my query.
how i can create temporary table?
What is oracle soa suite and what are its different components?
In a Standard form a DFF is disable?How we can Enable it?
Can u define DFF with in the DFF,How?
how many sections are there in report?
How to create a link between One dependent value set to another Dependent value set
5 Answers Indorama, ManSoft System, Syntel, TE Data,
how to debug the report?
2 Answers IBM, Qualcomm, Sierra Atlantica,
can we pass bind variablein lexical parameter?
whats the use of after parameter form and before report?
tell me the scenarios of the independent in reports
Exception Handilings?
Oracle Apps Technical 
