SQL Loader - Lob File

Card Puncher Data Processing

About

How to load a lob file with sql loader

Example

Control File

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

Datafile (sample.dat)

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

Reference







Share this page:
Follow us:
Task Runner