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

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.

6 Answers   Tech Mahindra,


what is flexfield qualifier?

3 Answers  


where the accounting related data is stored ? all type of accounting related data costing etc...

3 Answers  


In Oracle Apps Some tables ends with TL,VL,what is the significance of the TL and VL?

9 Answers   TCS,


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

4 Answers   CTS, iGate,






while doing the process of conversion if got any data error out what is the next step to reprocess

1 Answers  


Give a overview on Aol

2 Answers   Zensar,


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 .

1 Answers   TCS,


how i can create temporary table?

1 Answers   Zensar,


what are the sql attributes?

2 Answers  


WHAT IS THE VIEW IN ORACLE APPS?HOW IS IT CREATED?

4 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)