Interested to Buy Any Domain ? << Click Here >> for more details...
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 ?
- 2 Answers
- 12960 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / naga bhushan
In Control file
At the top add this line.
(OPTIONS SKIP=30,LOAD=60)
| Is This Answer Correct ? | 10 Yes | 3 No |
Answer / 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 |
Define multi org structure with example(take any businees).
we are inserting,update and delete the data we can do simultaniously, but it will show error in updation? what to do?
what are the error tables in OM
How many phases of implementation and what are those.
What and Who is the best Institute or Trainer for Oracle Apps Technical ?
How to link between inventory and OrderManagement.
What are ad-hoc reports?
in GL module specifing org_id or not?
what is unit of measure classes? give atleast two examples. name the underlying table.
can we use anchor propery in XML reports?if yes?explain?
Can u suggest me the best institute for Oracle apps Technical in Hyderabad?
Hi, can anybody tell me where is the requirement of Oracle Apps (functional+technical) in industry,Iwant to join there,If possible than call me---9313174232
Oracle Apps Technical 
