Hoe to skip middle of the record by using SQL*Loader?
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
What are the different components you should consider while defining a responsibility in oracle apps?
Hi, Anybody please send me the Oracle APPS 1i technical interview questions (Real time) as wel as sample resume also?
What is count(*) from po_vendors(any table)?
what are the prerequisites for costing transactions?
In hierarchical structure of a database? we have write query from where we should start?
In support project one ticket alloted which steps follows manualy tell me ?
What does appl_top directory contain?
Can we create tables in apps schema?
What is instead of trigger in where we will use?
what is pay run id ?
How can a process be deployed in soa?
what are the different transaction clauses in AR?
Can you explain the difference between architecture followed in 10g & 11g?
how to print multi lay outs,muti currency,muti language in xml publisher
What do you understand by concurrent programs?