1. Categories >> Software >> ERP CRM >> Oracle Apps >> Oracle Apps Technical
  2. Suggest New Category

In SQL Loader i have 100 Records to be loaded into my table.

How do i load the first 30 Records and skip the last 10
Records within a single .ctl file ?

So my total no.of records to be loaded would be 60.

Could anybody help me in this ?

Question Posted / kumar

Answer Posted / kumar

In Control file
At the top add this line.

(OPTIONS SKIP=30 RECORDS=60)


skip option skips first 30 records
Records option load 60 records
Automatically last 10 Records will not be considered by SQL
Loader.

Is This Answer Correct ?    1 Yes 3 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is count(*) from po_vendors(any table)?

639

Which oracle applications pl/sql standard apis you are familiar, have you used most of them?

634

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

659

what are the different transaction clauses in AR?

1598

What do you understand by soa?

689




Tell me where we find the status of order information?

667

Tell me how to debug the report?

637

A program must be written which accepts date parameter. The date parameter will accept data in the format DD/MM/YYYY. This data has to be validated and post validation, the following details have to be displayed for this date parameter 1. Input date must be defaulted to sysdate, It can be overridden by any other date. 2. Financial year should be displayed for this date parameter. Eg: If the input date is 30/11/2010, the financial year must be displayed as 1. From Date : 01-Aprr-2010 To Date: 31-Mar-2011 3. Calendar year and Calendar month must also be displayed. 4. The next payment cycle (say for EB), must be displayed based on this date parameter. 5. The previous payment must also be displayed based on this date.

1673

testing tools?

1750

What are do's and dont's of Interface?

1903

Hi, Anybody please send me the Oracle APPS 1i technical interview questions (Real time) as wel as sample resume also?

2126

Can we create tables in apps schema?

614

How to create a purchase order without a requisition?

626

Plz anybody send me Technical specification for AP Interface

2009

What are the different components of soa suite?

721