SQL Loader - Lob File

How to load a lob file with sql loader

SQL*Loader - (Parameter|Control) File

LOAD DATA 
INFILE 'sample.dat'
INTO TABLE person_table
FIELDS TERMINATED BY ','
(
   name      CHAR(20),
   ext_fname    FILLER CHAR(40),
   "RESUME"     LOBFILE(ext_fname) TERMINATED BY EOF
 )

where:

• FILLER is a field that fill a variable named ext_fname. It takes the relative path from the sqlloader running directory to the file to load
• RESUME is the lob column of the database
• LOBFILE is a function that transform the file in a lob file where you can set the file characterset. See lobfile_spec for the complete syntax

Johny Quest,jqresume.txt,
Speed Racer,'/private/sracer/srresume.txt',

• Examples of Loading LOB Data from LOBFILEs
• Loading LOB Data from LOBFILEs