in sql loader,i have 100 records in my flatefile, i want to skip the 80 to 90

in sql loader,i have 100 records in my flatefile, i want to
skip the 80 to 90 records .please help me

Question Posted / praveen

4 Answers
12501 Views
CTS, iGate, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

in sql loader,i have 100 records in my flatefile, i want to skip the 80 to 90 records .please hel..

Answer / naresh kotapati

by using filler option we can omitt the records

Is This Answer Correct ?

13 Yes

3 No

in sql loader,i have 100 records in my flatefile, i want to skip the 80 to 90 records .please hel..

Answer / venki

By using "Filler" Command
OR
By Usins "When" Condition

Is This Answer Correct ?

7 Yes

5 No

in sql loader,i have 100 records in my flatefile, i want to skip the 80 to 90 records .please hel..

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

in sql loader,i have 100 records in my flatefile, i want to skip the 80 to 90 records .please hel..

Answer / balaji

options(skip=80,load=10)
load data
-------
-------

Is This Answer Correct ?

8 Yes

10 No

Post New Answer

More Oracle Apps Technical Interview Questions

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

3 Answers Oracle,

what is organization id

3 Answers

Give a overview on Aol

2 Answers Zensar,

Define MultiOrg Structure

5 Answers Convergys,

When loading data from staging table to interface table , how to reload the invalid record once again ?

6 Answers Accenture,

A file has both header and corresponding lines. Explain design to load this data into respective interface tables.

1 Answers Satyam,

In which table or database definition we can find the link of organization and operation units.

2 Answers IBM,

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.

3 Answers IBM,

What is secuirity's in R12 features.

1 Answers KPIT,

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 ?

7 Answers Satyam,

Can u suggest me the best institute for Oracle apps Technical in Hyderabad?

16 Answers

Is it possible calling from one report to another? if possible means tell me ?

3 Answers Intelligroup, Satyam,

For more Oracle Apps Technical Interview Questions Click Here