Interested to Buy Any Domain ? << Click Here >> for more details...
Hoe to skip middle of the record by using SQL*Loader?
- 5 Answers
- 13735 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 |
We have to show a logo/image in a report? what are the steps and which format it is?whether in pdf format is applicable or not?
hi gurus my name is ramesh i was completed orcale apps technical trainning i wnt to put 3+yrs experience is it correct r not ,if any freshers jobs are available in market pls suggest me. my mail id rameshmcaou@gmail.com and contact no is 9000342411
which parameters passed in report in oracle developer how to pass
Can you define an erp system?
Pls tel me the best text book for Oracle Apps 11i Tech? & I want D2K Text book also?
What are the different components you should consider while defining a responsibility in oracle apps?
how can we get odd numbered pages in output of a report
What is the difference between buyer&employee in PO module?
What is sca and how is it useful?
In oracle application how do you debug or trace errors?
can we execute one concurrent program through another concurrent program?
What should be the batch size (number of customer records) general guidelines for optimal performance?
Oracle Apps Technical 
