Loading Records Based on a Condition
You can choose to load or discard a logical record by using the WHEN clause to test a condition in the record.
The WHEN clause appears after the table name and is followed by one or more field conditions. The syntax for field_condition is as follows:
For example, the following clause indicates that any record with the value "q" in the fifth column position should be loaded:
WHEN (5) = 'q'
A WHEN clause can contain several comparisons, provided each is preceded by AND. Parentheses are optional, but should be used for clarity with multiple comparisons joined by AND. For example:
WHEN (deptno = '10') AND (job = 'SALES')
-
"Using the WHEN_ NULLIF_ and DEFAULTIF Clauses" for information about how SQL*Loader evaluates
WHENclauses, as opposed toNULLIFandDEFAULTIFclauses -
Case study 5, Loading Data into Multiple Tables, for an example of using the
WHENclause (see "SQL*Loader Case Studies" for information on how to access case studies)