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 ?
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 |
What are basic steps for AIM?
what is the purpose of standard cost update?
Is that Possible To create package without Specification , If Yes Give any Examples
What are file in oracle.
Is PlaceHolderColumn Function or Procedure? Why we don't write any code in that?
what type of testing u r doing?
HOW CAN U KNOW THE RESPONSIBILITY BELONGS TO OPERATING UNIT LEVEL OR NOT
what r the objects u have to do in u experiance
what is count(*) from po_vendors(any table)? what does it do and what is count(1) from po_vendors(any table)? what is count(0) from po_vendors(any table) the out put is same what is the difference
What is the use of format trigger?
Difference between set of books id and ledger id in r12 ?
what are version control tools used in oracle apps?