Hoe to skip middle of the record by using SQL*Loader?
- 5 Answers
- 12327 Views
- I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
List the various types of value set.
is it possible to run the interface without using oracle apps?
How to move the one file from one instance to another instance? And your scripts also?
how can i print random rows in plsql table
how do you describe O2C along with tables
A program must be written which accepts date parameter. The date parameter will accept data in the format DD/MM/YYYY. This data has to be validated and post validation, the following details have to be displayed for this date parameter 1. Input date must be defaulted to sysdate, It can be overridden by any other date. 2. Financial year should be displayed for this date parameter. Eg: If the input date is 30/11/2010, the financial year must be displayed as 1. From Date : 01-Aprr-2010 To Date: 31-Mar-2011 3. Calendar year and Calendar month must also be displayed. 4. The next payment cycle (say for EB), must be displayed based on this date parameter. 5. The previous payment must also be displayed based on this date.
pls send me out bound code of supplers,site,bankiformation code pls as soon as
What do you understand by a set of books?
List the types of flexfield?
Can u give the Documentation of Custom.pll in oracle apps
Can you differentiate between mediator and osb?
What is count(*) from po_vendors(any table)?
tell me the scenarios of the independent in reports
Pls tel me the best text book for Oracle Apps 11i Tech? & I want D2K Text book also?
please send me forms, xml pulisher questions,answers
