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
- 12953 Views
- I also Faced
- E-Mail Answers
Answer Posted / naga bhushan
In Control file
At the top add this line.
(OPTIONS SKIP=30,LOAD=60)
| Is This Answer Correct ? | 10 Yes | 3 No |
Post New Answer View All Answers
Explain what are the tables of auto invoice?
In hierarchical structure of a database? we have write query from where we should start?
what are the different transaction clauses in AR?
is it possible to run the interface without using oracle apps?
Which oracle applications pl/sql standard apis you are familiar, have you used most of them?
what is global tempory table?
Suppose for report I have to parameters those are from_date and to_date, so to_date should be greater when compare to from_date, if we are giving to_date is lessthen it must shows some error how we will make?
How can a process be deployed in soa?
What do you understand by soa and what are the benefits of using this architecture?
do you know is it possible to run the interface without using oracle apps?
tell me the scenarios of the independent in reports
Can you explain the difference between architecture followed in 10g & 11g?
List of all the modules under Manufacturing, Finance and Distribution in oracle applications?
What is instead of trigger in where we will use?
how can i print random rows in plsql table
