Hoe to skip middle of the record by using SQL*Loader?
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 customize the Reports?
please any one provide the oracle erp technical interview questions on modules(PO,AP,AR,INV,GL,OM)wise to my mail id..narendra_609@yahoo.co.in
what are the different types of triggers in reports
how to change the logo in template dynamically?
what are the sql attributes?
what is Flex mode and Confine mode?
How does accounting occured in Expense Reporting?
In Oracle Apps Some tables ends with TL,VL,what is the significance of the TL and VL?
hi all.i am in need of some sample codes for oracle apps manufacturing interfaces.If any of u have,plz send it to me . Thank you.
Steps for DFF registration
we have clients in different countries, we can run report in different places, if i want to display particular language,country,currency everything displays for that country how?
how to initialize applications?