sqlload函数使用

 

1.substr和substrb

[oracle@lenovo sqlload]$ more tb_test01.ctl    
Load DATA
LENGTH SEMANTICS CHARACTER
INFILE '/tmp/mytest.txt'
truncate into table tb_test01
FIELDS TERMINATED BY "€"
TRAILING NULLCOLS
(
id
,name char "substrb(:name, 1, 30)"
,name1 "substrb(:name, 1, 30)"
)

 

注意这里substr各参数之间需要带上空格