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 the different calculation columns available in reports?
while registering executable and concurent program we register both with application name|<oracle purchasing>? so my question is why we are defining in both concurent program and executable?
IN WHICH MODULE THE LEGAL ENTITY COMES?
We have to show a logo/image in a report? what are the steps and which format it is?whether in pdf format is applicable or not?
Are you familiar with internet architecture of oracle apps 11i?
In sequence i want to 11 and 15th values how we will write?
I am insert in data to a table X .Which one is better while writing commit statement After each row inset or after all row insert to table.
After completing Report customization process.suppose we have 10 report parameter in report so, that we re-register that parameter in concurrent program?
what is the purpose of standard cost update?
Tell me some errors names and number what u got while developing the reports?
Tell me some thing about SQL-LOADER.
Oracle E-Business suite?