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
Example 11
skip CSV columns
make a unique index unusable
Load binary data (blobs)
Load binary data (long raw)
Index