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 |
What is GLOBAL TEMPORARY TABLE and It's significance ?
If we have a repeated record in a table. But the repeated record how i can transfer from table to nested table?
What is the Use of User Exit in Oracle apps and when we are developeing the new report you need to pass one parameter called P_CONC_REQUEST_ID,what is the use of this parameter and is it mandatory.Can't we develop report without this User exit's and P_CONC_REQUEST_ID parameter
what is aim methodolozy
Can u define DFF with in the DFF,How?
How to attach the multiple templates in XML Pub Report?
I am insert in data to a table X .Which one is better while writing commit statement After each row inset or after all row insert to table.
in procedure how to return a value
what is difference between d2k report and oracle apps report
10 Answers Seven Hills, Wipro,
how to move the one file from one instance to another instance?and ur scripts also?
How to link between inventory and OrderManagement.
What is template?