load data infile方式数据无法正确导入的问题导入数据中有0开头数据不对

Question

Load data
Infile '/var/test/tmp/DALLUSERRTMP.cvs'
replace delete Into table KDCS_BROADBANDUSER
(ID "KDCS_BROADBANDUSER_SEQ.NEXTVAL",
ACCOUNT terminated by ',',
BANDWIDTH terminated by ',',
PROVINCE terminated by ',',
CITY terminated by ',',
CONNECTTYPE terminated by ',',
ACCOUNTTYPE terminated by ',')数据格式：
02700428056,4M,71,0027,3,0
02700428788,4M,71,0027,3,0
02700428791,4M,71,0027,3,0
02700428793,4M,71,0027,3,0
02700428087,10M,71,0027,3,0
02700428790,10M,71,0027,3,0
02700400115,4M,71,0027,3,0
导入进去02700428056就成了2700428056了，请问是咋个解决这个问题呢？Oracle Load Data

Answer 1

数据库字段是varchar2(30)类型，不是数值类型啊