Oracle: SQL Loader Example: conversion of numbers to characters

create table tq84_sql_loader_7 (
  field_1       varchar2(10),
  field_2       varchar2(10),
  field_3       varchar2(10),
  field_4       varchar2(10)
);

load data
infile 'load_7.dat' "str '\r\n'"
insert
into table tq84_sql_loader_7
fields terminated by ','
(
  field_3      char,
  field_2      char,
  field_4      char,
  field_1      char
)

one,two,three,four
1,2,3,4

start create_table

host  sqlldr control=load_7.ctl userid=rene

select * from tq84_sql_loader_7;

drop table tq84_sql_loader_7;

prompt
prompt Check load_7.bad file
prompt