Interested to Buy Any Domain ? << Click Here >> for more details...
Hoe to skip middle of the record by using SQL*Loader?
- 5 Answers
- 13968 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 is a value set? List its various types.
what is user exit and wat program do we write in user exit?
What is responsibility and how u attach
can we use anchor propery in XML reports?if yes?explain?
How we print the multi language in report?can any one give me step bye step explanation.
2 Answers HCL, IBM, Tech Mahindra,
If the valueset if of type –TABLE then how many tables can we attach in the valueset ?
how do you describe O2C along with tables
how to enable Zoom function and steps?
what are external tables? how can we use external table instead of sql * loader to load data from flat file to staging table?
Plz anybody send me Technical specification for AP Interface
HOW CAN U KNOW TABLE IS REGISTERD IN APPS?
Can u define exceptions twice in same block?
Oracle Apps Technical 
