in sql loader,i have 100 records in my flatefile, i want to
skip the 80 to 90 records .please help me
- 4 Answers
- 12884 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 |
WHAT IS REFCURSOR IN ORACLE ?
what is lexical parameter?
If the flat file is having the duplicate records in the interface how can you restrict while transferring the flat file data in to interface tables?
in oracle workflow if i want to send a mail to the user after sending if the user didn't approve the mail after 10 mins it is automatimatically approved how we can approach?
How to develop XML report without rdf?
what is back order in OM
what r the objects u have to do in u experiance
How to link modules in apps
what are the important table names in purchasing?
How we will receive the work from the client? what type of documents we will develop in the entire implementation project? plz tell me the total scinario?
2 Answers Deloitte, Intelligroup,
How to create user and how u attach with responsibility.
In a table their 20 records.I had update 6 records???How can see and retrieve particular 6 records.i.e.,Latest updated.
10 Answers HCL, TCS,
Oracle Apps Technical 
