Interested to Buy Any Domain ? << Click Here >> for more details...
Hoe to skip middle of the record by using SQL*Loader?
- 5 Answers
- 14041 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 |
Steps for DFF registration
What is multoorg and what is it's level or structure
Is that Possible To create package without Specification , If Yes Give any Examples
what is user exit and wat program do we write in user exit?
What is the difference between base table and multi-org table?
In which directory your flatfile is given?if u connected different instance where it is find?
What is REF Cursor?
19 Answers Infosys, Intelligroup,
Types of cursors?
Can anybody tell me, What is the Implementation Process?
what is lexical parameter?
Which one Module is Biggest Module in oracle apps?
What is ERP? Architecture of apps?
Oracle Apps Technical 
