Interested to Buy Any Domain ? << Click Here >> for more details...
Hoe to skip middle of the record by using SQL*Loader?
- 5 Answers
- 13746 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 do u identity its name of report?
How is choreography different from orchestration?
Suppose for report I have to parameters those are from_date and to_date, so to_date should be greater when compare to from_date, if we are giving to_date is lessthen it must shows some error how we will make?
How to register a form and stored procedure in oracle apps
Matrix Report: Simple, Group above, Nested
What is the maximum number of statements that can be specified in a trigger statement?
Is that Possible To create package Overloading , If Yes Give any Examples
API?s FOR CUSTOMER INTERFACE? Tell me some API's?
why do we validate the records while developing interface?
what are the profiles
What should be the batch size (number of customer records) general guidelines for optimal performance?
Define MultiOrg Structure
Oracle Apps Technical 
