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
- 12704 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 |
about TCA architecture
What repots or concurrent program run to transfer data from Inventory to GL.
what is the difference between request group and request security in oracle apps?
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
Except the SRS window in which we can submit the concurrent program.
What are the Major differences between appcore.pll and appcore2.pll
5 Answers Infosys, Sierra Atlantica,
What are the benefits of using soa architecture?
Which modules of oracle apps have forms and reports? I am a beginner in oracle apps so kindly answer my query.
what are the profiles
If there is any issue then whom do you report.(this is imp question for every interview)
How to create a link between One dependent value set to another Dependent value set
5 Answers Indorama, ManSoft System, Syntel, TE Data,
Can u define exceptions twice in same block?
Oracle Apps Technical 
