in sql loader,i have 100 records in my flatefile, i want to
skip the 80 to 90 records .please help me
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 |
wht is the use of Xml reports over reports6i?
What is request group
Difference between triggers and procedures?
types of invoices?
7 Answers BelAir Store, Convergys, Wings Biotech,
What is SRW Package? (Sql Report Writer)
WHAT IS REFCURSOR IN ORACLE ?
what is the difference between %_all and %_f tables
What are the different components of soa suite?
what are the prerequisites for costing transactions?
WHAT IS USE OF APPS API?
There are set of records to be processed from staging table into interface table. If one record fails the entire set of data should be rejected.
explain registration steps of a concurrent program.