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



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

what is the difference between oracle applications ebs 11.5.9 and 11.5.10.2 and can anyone suggest the release dates of the versions

1 Answers  


How we print the multi language in report?can any one give me step bye step explanation.

2 Answers   HCL, IBM, Tech Mahindra,


how do you describe O2C along with tables

1 Answers   TCS,


what is global tempory table?

2 Answers   BirlaSoft,


pls send me out bound code of supplers,site,bankiformation code pls as soon as

0 Answers  


35—how to create ldt lct files? 36—how to tranfor on file from one instance to another instance?

2 Answers   Accenture,


How to pass data into EXECUTE_IMMEDIATE statement in plsql body ?

2 Answers   Oracle,


Is PlaceHolderColumn Function or Procedure? Why we don't write any code in that?

3 Answers   Oracle,


What is function?

2 Answers   Motorola,


In custom.pll what are the events we can Not write.

1 Answers  


what are the error tables in AP?

6 Answers  


wht r the basetables of customer interface?

2 Answers  


Categories
  • Oracle Apps Technical Interview Questions Oracle Apps Technical (547)
  • Oracle Apps Financial Interview Questions Oracle Apps Financial (793)
  • Oracle Apps Manufacturing Interview Questions Oracle Apps Manufacturing (53)
  • Oracle Apps HRMS Interview Questions Oracle Apps HRMS (169)
  • Oracle Apps CRM Interview Questions Oracle Apps CRM (9)
  • Oracle Apps SCM Interview Questions Oracle Apps SCM (141)
  • Oracle Install Base Interview Questions Oracle Install Base (62)
  • Oracle Service Contracts Interview Questions Oracle Service Contracts (101)
  • Oracle Apps AllOther Interview Questions Oracle Apps AllOther (114)