Loading delimited (variable length) data:
In the first example we will show how delimited (variable length) data can be loaded into Oracle:
INTO TABLE load_delimited_data
FIELDS TERMINATED BY "," OPTIONALLY ENCLOSED BY '"'
22222,”A, B, C, D,”
NOTE: The default data type in SQL*Loader is CHAR (255). To load character fields longer than 255 characters, code the type and length in your control file. By doing this, Oracle will allocate a big enough buffer to hold the entire column, thus eliminating potential “Field in data file exceeds maximum length” errors. Example:
resume char (4000),
Loading positional (fixed length) data:
If you need to load positional data (fixed length), look at the following control file example:
INTO TABLE load_positional_data
(data1 POSITION (1:5),
For example, position (01:05) will give the 1st to the 5th character (11111 and 22222).