Search notes:

Oracle: SQL Loader Example: skip CSV columns

This example loads a CSV file five columns (or values per record). However, the destination table only contains three columns. This is possible by using the filler keyword for the values that should not be loaded.

create table tq84_sql_loader_12 (
  col_1  varchar2(10),
  col_3  varchar2(10),
  col_5  varchar2(10)
);

Github repository Oracle-Patterns, path: /SQLLoader/ex_12_skip-columns/create_table.sql

load data
infile 'data.csv'
insert
into table tq84_sql_loader_12
fields 
  terminated by ',' 
(
  col_1           ,
  col_2     filler,
  col_3           ,
  col_4     filler,
  col_5
)

Github repository Oracle-Patterns, path: /SQLLoader/ex_12_skip-columns/load.ctl

col_1,col_2,col_3,col_4,col_5
one,two,three,four,five
eins,zwei,drei,vier,fünf

Github repository Oracle-Patterns, path: /SQLLoader/ex_12_skip-columns/data.csv

@create_table.sql

host sqlldr userid=rene/rene  control=load.ctl

select * from tq84_sql_loader_12;

drop table tq84_trailing_nullcols purge;

Github repository Oracle-Patterns, path: /SQLLoader/ex_12_skip-columns/all.sql

Oracle: SQL Loader Example: skip CSV columns

See also