Specifying Default Data Delimiters

If all data fields are terminated similarly in the data file, then you can use the FIELDS clause to indicate the default termination and enclosure delimiters. The syntax is as follows:

fields_spec

Description of GUID-F43C0C25-0B2B-468B-8BCF-021D6B19A04D-print.eps follows

Description of the illustration GUID-F43C0C25-0B2B-468B-8BCF-021D6B19A04D-print.eps

termination_spec

Description of GUID-81A3B1F7-4D98-461F-828A-2BF8D1789FAE-print.eps follows

Description of the illustration GUID-81A3B1F7-4D98-461F-828A-2BF8D1789FAE-print.eps

Note:

Terminator strings can contain one or more characters. Also, TERMINATED BY EOF applies only to loading LOBs from a LOBFILE.

enclosure_spec

Description of GUID-D4BDF7D8-EBEA-451A-8BCB-32B1C6C3CDA5-print.eps follows

Description of the illustration GUID-D4BDF7D8-EBEA-451A-8BCB-32B1C6C3CDA5-print.eps

Note:

Enclosure strings can contain one or more characters.

You can override the delimiter for any given column by specifying it after the column name. Case study 3, Loading a Delimited Free-Format File, provides an example. (See "SQL*Loader Case Studies" for information on how to access case studies.)