Interested to Buy Any Domain ? << Click Here >> for more details...
Hoe to skip middle of the record by using SQL*Loader?
- 5 Answers
- 13772 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 |
How to move the one file from one instance to another instance? And your scripts also?
what is tuning in oracle apps technical
is it possible to run the interface without using oracle apps?
What is P2P cycle.
27 Answers Accenture, Deloitte, EE Limited, EXL, IBM, Tech Mahindra,
what are the tables of auto invoice.
how many layout sections are tehre in layout editor?
wht is the use of Xml reports over reports6i?
we are inserting,update and delete the data we can do simultaniously, but it will show error in updation? what to do?
where to define interorganization transaction charges and what are the different options?
Can you have two stored functions with in the same name?
How to find which company will be conducted Oracle appa interview? Plz help me
how many sections are there in report?
Oracle Apps Technical 
