in sql loader,i have 100 records in my flatefile, i want to
skip the 80 to 90 records .please help me
- 4 Answers
- 13134 Views
- CTS, iGate, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / naresh kotapati
by using filler option we can omitt the records
| Is This Answer Correct ? | 13 Yes | 3 No |
Answer / venki
By using "Filler" Command
OR
By Usins "When" Condition
| Is This Answer Correct ? | 7 Yes | 5 No |
Answer / vinay thakur
We can not skip in btw records like 80-90
We can skip starting records and load remaining records..
| Is This Answer Correct ? | 3 Yes | 1 No |
Answer / balaji
options(skip=80,load=10)
load data
-------
-------
| Is This Answer Correct ? | 8 Yes | 10 No |
define steps of assigning items to an organization.
what is repeting frame?
What are the validations you don in .CTL file in inbound interface process?
Could any one tell me the steps of conversions and what kind of validations and exceptions do we use during this conversion? Please do answer in detail. what program do we write in user exit in reports?
Need Training & Internship with guaranteed Job in ERP - Oracle Apps Tech?
While importing data into interface tables,if u got number of records are error(like more than 1000 records are error),how to imform user?
Can we customize a form with out template.fmb
tell me the scenarios of the independent in reports
A file has both header and corresponding lines. Explain design to load this data into respective interface tables.
What is the Use of User Exit in Oracle apps and when we are developeing the new report you need to pass one parameter called P_CONC_REQUEST_ID,what is the use of this parameter and is it mandatory.Can't we develop report without this User exit's and P_CONC_REQUEST_ID parameter
in sql *loder how to skip the middle records ex:from 10th to 20th records i want to skip?
How is choreography different from orchestration?
Oracle Apps Technical 
