Interested to Buy Any Domain ? << Click Here >> for more details...
in sql loader,i have 100 records in my flatefile, i want to
skip the 80 to 90 records .please help me
- 4 Answers
- 13832 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 |
How many parameters we can pass through pl/sql program in Oracle apps
Difference between set of books id and ledger id in r12 ?
WHAT IS REFCURSOR IN ORACLE ?
Assume i have three Procedures defined in a Package Spec. I have created the Package Specification. now i create the Package Body by including the three procedures in addition to that i include a fourth procedure which is not included in my Package Spec. I compile the Package Body. Will the Package body Compile ? What will the end result ? what will happen if the execute the package by calling the 4th procedure ?
How can you achieve loose coupling in soa framework?
How to pass data into EXECUTE_IMMEDIATE statement in plsql body ?
differentiate between intra & inter UOM class conversion with examples.
What is GLOBAL TEMPORARY TABLE and It's significance ?
What is set function in sql .E.g.What is difference between union and union all
in one report using two layout models.if yes how to do
What is the Lookup's and what is the use of lookup's?
What is ERP? Architecture of apps?
Oracle Apps Technical 
