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 |
in procedure how to return a value
what is repeting frame?
why r u move in the cus_top only why not move another top
What are basic steps for AIM?
How to attach the multiple templates in XML Pub Report?
What is the maximum number of statements that can be specified in a trigger statement?
In xml report, how to print the headings in every page?
When you run he report you have to get only that particular organization po numbers or item number how can do it?
Tell me where we find the status of order information?
Can u define DFF with in the DFF,How?
INBOUND INTERFACE: Suppose I have 100 Records of employees in flat file.When moving the records from flat file to STAGING table using >CTl file, I want to restrict the records whose salary is less than 500.what are the validations(or conditions) you write to achieve this.
How to create a link between One dependent value set to another Dependent value set
5 Answers Indorama, ManSoft System, Syntel, TE Data,