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
14050 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

Which one Module is Biggest Module in oracle apps?

3 Answers Questam,

in procedure how to return a value

2 Answers Wipro,

testing tools?

0 Answers BirlaSoft, Convergys,

what is mean by confine mode and flexi mode?

2 Answers

while running a interface if we get 100 records as erors. how to debug it.

2 Answers Zensar,

Tell me some errors names and number what u got while developing the reports?

1 Answers

wht is format triger?

4 Answers

What does appl_top directory contain?

0 Answers

what is the back ground program run while transferring data from OM to AR?

4 Answers Qwest,

Do you know what are user profiles in apps. Any examples you can give?

0 Answers

What is workflow?Explain with a example?

2 Answers Oracle,

Is there any limitations on responsibility assigned to a apps user?

6 Answers ESS,

For more Oracle Apps Technical Interview Questions Click Here