ENCLOSED_BY

Default: The default is that there is no enclosure character.

Purpose

The ENCLOSED_BY parameter specifies a field enclosure character.

Syntax and Description

ENCLOSED_BY=['char'|x'hex-char']

The enclosure character must be a single character. It can be in hexadecimal notation.

Restrictions

  • The same character must be used to signify both the beginning and the ending of the enclosure.

Example

In the following example, the field data is enclosed by the '/' character (forward slash).

> sqlldr hr TABLE=employees ENCLOSED_BY='/'