Keywords
- datatype_name
Name of one of the datatypes described later. Different datatype clauses apply to different datatypes. Two parts of the datatype clause are common across multiple datatypes: enclosure and termination.
- enclosure
The syntax for this clause is:
[OPTIONAL] ENCLOSED [BY] ['string' | X'hex_value'] [AND 'string' | X'hex_value']
You can also use the OPTIONAL keyword to indicate that the enclosing characters are optional, but only following the TERMINATED BY clause. The AND keyword indicates a different ending character from the initial character.
- termination
The syntax for this clause is:
{DELIMITED [BY]}|{TERMINATED [BY]} WHITESPACE|X'hex_value' | 'string' | EOFwhere WHITESPACE indicates that the termination of the field is any type of whitespace, including space characters, tab characters, and newline characters. EOF stands for end-of-file, and is primarily used for loading LOBs.
The datatype_names and their syntax are:
CHAR length enclosure termination DATE length mask enclosure termination
where mask is the date mask used by the Oracle TO_DATE function to convert the incoming date.
{INTEGER | DECIMAL | FLOAT | ZONED} [EXTERNAL] length enclosure termination GRAPHIC [EXTERNAL] lengthwhere length is the length of the raw graphic file in terms of double bytes. The EXTERNAL keyword indicates that the graphic is enclosed by shift-in and shift-out characters.
RAW length VARCHARC | VARRAWC (length[,max_bytes])
For these datatypes, the length of the field is indicated in the first ...