Keywords
- column_name
Name of the database column into which you want data for the field to be loaded.
- [BOUND] FILLER
Indicates that a field in the INFILE is not loaded into the target table. This keyword was introduced with Oracle8i. A bound filler field, new in Oracle9i, is a filler field that can be used with the NULLIF or DEFAULTIF clauses.
- generated
Causes SQL*Loader to use a generated value for the field. The options for generation are:
- RECNUM
The record number for the record
- SYSDATECONSTANT “string”SEQUENCE
Similar to RECNUM, but does not include a sequence number for bad records. The SEQUENCE specification can include the following: the keyword COUNT, which starts the sequence with a number higher than the count of the records already in the table; the keyword MAX, which starts the sequence with the integer higher than the maximum value of the column; an integer, which is the integer with which to start the sequence; and an increment, which is a positive integer greater than 1, indicating how the sequence should be incremented for each record.
- start | *
Starting position of the field in the input record. The first byte is position one. Using * in this position indicates that this field starts immediately after the previous field or with the first byte of the record for the first field.
- offset
Optional offset that you can have SQL*Loader add to the position represented by the * character.
- end
Position of the last byte of data in the field. This is optional. If you omit the ending ...