Default: If the CSV parameter is not specified on the command line, then SQL*Loader express assumes that the CSV file being loaded contains data that has no embedded characters and no enclosures.
If CSV=WITHOUT_EMBEDDED is specified on the command line, then SQL*Loader express assumes that the CSV file being loaded contains data that has no embedded characters and that is optionally enclosed by '"'.
Purpose
The CSV parameter provides options that let you specify whether the comma-separated value (CSV) format file being loaded contains fields in which record terminators are embedded.
Syntax and Description
CSV=[WITH_EMBEDDED | WITHOUT_EMBEDDED]
The valid options for this parameter are as follows:
WITH_EMBEDDED--This option means that there may be record terminators included (embedded) in a field in the record. The record terminator is newline. The default delimiters are TERMINTATED BY "," and OPTIONALLY_ENCLOSED_BY '"'. Embedded record terminators must be enclosed.
If the CSV file contains many embedded record terminators, it is possible that performance may be adversely affected.
WITHOUT_EMBEDDED--This option means that there are no record terminators included (embedded) in a field in the record. The record terminator is newline. The default delimiters are TERMINTATED BY "," and OPTIONALLY_ENCLOSED_BY ' " '.
Restrictions
Normally a file can be processed in parallel (split up and processed by more than one execution server at a time). But in the case of CSV format files with embedded record terminators, the file must be processed by only one execution server. Therefore, parallel processing within a data file is disabled when CSV=WITH_EMBEDDED.
Example
The following example processes the data files as CSV format files with embedded record terminators.
> sqlldr hr TABLE=employees CSV=WITH_EMBEDDED