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 |
INBOUND INTERFACE: Suppose I have 100 Records of employees in flat file.When moving the records from flat file to STAGING table using >CTl file, I want to restrict the records whose salary is less than 500.what are the validations(or conditions) you write to achieve this.
what is flexfield qualifier?
where the accounting related data is stored ? all type of accounting related data costing etc...
In Oracle Apps Some tables ends with TL,VL,what is the significance of the TL and VL?
in sql loader,i have 100 records in my flatefile, i want to skip the 80 to 90 records .please help me
while doing the process of conversion if got any data error out what is the next step to reprocess
Give a overview on Aol
what is the difference between multiorg views and multiorg tables
2 Answers Immense Source, Intelligroup, TCS,
Hi all I am in big career dilemma. I am currently working as Oracle Apps functional consultant scm with 1 yr of exp. I am thinking to do mba. Hos it will work to di MBA in scm or operations. Please guide .
how i can create temporary table?
what are the sql attributes?
WHAT IS THE VIEW IN ORACLE APPS?HOW IS IT CREATED?