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 |
How can u call a standard interface program from sql or pl/sql code?
How to migrate .rdf file from dev instance to test instance?
3 Answers Accenture, Oracle, TCS, Tech Mahindra, Unisoft Infotech,
WHAT IS THE FORWARDREFERENCE IN PL/SQL?
In Oracle Apps Some tables ends with TL,VL,what is the significance of the TL and VL?
what are the profiles
Hi Experts How to Create a purchase order without a requisition ?
6 Answers Amdocs, KPMG, Oracle,
What is SRW Package? (Sql Report Writer)
types of invoices?
7 Answers BelAir Store, Convergys, Wings Biotech,
In thet custom.pll what are the events we can write.
Types of cursors?
how can develope the po variance and po summary report? with tables mandatory columns and query please?
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?