Interested to Buy Any Domain ? << Click Here >> for more details...
Hoe to skip middle of the record by using SQL*Loader?
- 5 Answers
- 14051 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / veluruga
By using FILLER Command, it will not accept the data and it inserts the NULL values.
Ex:
(Empno,
Ename,
Date FILLER);
| Is This Answer Correct ? | 8 Yes | 4 No |
Answer / kutti
FILLER is used to skip the entire column not particular set of data .
| Is This Answer Correct ? | 3 Yes | 0 No |
Answer / nuthan
At cmd prompt
Sqlldr user/pwd@inst
Control= d:/filename.ctl load 10 skip 1
| Is This Answer Correct ? | 0 Yes | 0 No |
Answer / sree
1. Use When Clause to load selective records to base tables.
2. Unwanted records get skipped and placed in warning files.
3. If you want skip warning then load unwanted records to temporary tables and then delete them.
| Is This Answer Correct ? | 2 Yes | 3 No |
What are the Major differences bteween key flexfields ,descriptive flexfields
4 Answers Sierra Atlantica, TechBulls,
Can anybody tell me, What is the Implementation Process?
maximum how many parameters we can pass through pl/sql stored procedure to oracle apps?how many mandatory parameters we can pass through pl/sql program to oracle apps11i?
what is mutating table and mutating error and how to solve that?
What should be the batch size (number of customer records) general guidelines for optimal performance?
what is meant by boilerplates?
List the various types of value set.
What r the validation types?
how to initialize applications?
How to print multi currency,multi language in xml?
what is the differences between internal requisition and internal sales order?
Challenges faced during upgradation of 11i to R12
Oracle Apps Technical 
