Search notes:

Oracle SQL Loader examples

Insert records with fixed width values

Insert data that is separated by commas (i.e. CSV files)

Selectively insert records according to a criteria

Struggling with optionally_enclosed_by in SQL Loader express.

Insert a record into one or another table, according to a criteria

Load dates / specify date formats

Explicitly declare a column's width in the control file in order to prevent the Field in data file exceeds maximum length error message.

Conversion of numbers to varchars

Load csv file with a header

Load dates - use sysdate for empty values

Evaluate a value with case when

Call a PL/SQL function to determine a value

skip CSV columns

make a unique index unusable

Load binary data (blobs)

Load binary data (long raw)