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 |
hi gurus my name is ramesh i was completed orcale apps technical trainning i wnt to put 3+yrs experience is it correct r not ,if any freshers jobs are available in market pls suggest me. my mail id rameshmcaou@gmail.com and contact no is 9000342411
what is organization id
Give a overview on Aol
Define MultiOrg Structure
When loading data from staging table to interface table , how to reload the invalid record once again ?
A file has both header and corresponding lines. Explain design to load this data into respective interface tables.
In which table or database definition we can find the link of organization and operation units.
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.
What is secuirity's in R12 features.
Assume i have three Procedures defined in a Package Spec. I have created the Package Specification. now i create the Package Body by including the three procedures in addition to that i include a fourth procedure which is not included in my Package Spec. I compile the Package Body. Will the Package body Compile ? What will the end result ? what will happen if the execute the package by calling the 4th procedure ?
Can u suggest me the best institute for Oracle apps Technical in Hyderabad?
Is it possible calling from one report to another? if possible means tell me ?
3 Answers Intelligroup, Satyam,