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
- 12852 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 |
in one report using two layout models.if yes how to do
What is the Exception. Types of exception, Difference between those. And example
Types of cursors?
What are the files we submit while your program move to testing instance?
cursor 1 and cursor 2 are there did you open both the cursors at a time or not?
what is item status? name the related table.
how to move the one file from one instance to another instance?and ur scripts also?
What is secuirity's in R12 features.
what is the database size you used?
What are the Import Programs We need to run after creating Interface table for all modules
how to customize the report,please tell me customization steps
diff between key and descriptive flexfield.
Oracle Apps Technical 
