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
- 13873 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 to avoid duplicate data while uploading data from flatfile to staging table? some validations
what is item status? name the related table.
tell me the scenarios of the independent in reports
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 ?
diff between key and descriptive flexfield.
How is choreography different from orchestration?
Can 2 functions have same name & input parameters but differ only by return datatype ?
What is P2P cycle.
27 Answers Accenture, Deloitte, EE Limited, EXL, IBM, Tech Mahindra,
IN GL,AP,PO,AR WHICH MODULE DOESNOT HAVE _ALL TABLES THEN WHY?
Is PlaceHolderColumn Function or Procedure? Why we don't write any code in that?
Pls tel me the best text book for Oracle Apps 11i Tech? & I want D2K Text book also?
What is OM Cycle and What do u mean by Alternate Item
Oracle Apps Technical 
