Question

oracle 数据库sqlloder 导入数据以后number类型的数据导入不完全，比如：1.23 导入以后的数据变成：-.23

ctl文件：LOAD DATAINFILE 'C:\cygwin64\data\stock_date_line\comb.csv'BADFILE 'C:\cygwin64\data\sqlloder\DATA.BAD'DISCARDFILE 'C:\cygwin64\data\sqlloder\DATA.DSC'DISCARDMAX 1000TRUNCATEINTO TABLE "table_name"FIELDS TERMINATED BY ','TRAILING NULLCOLS(period_date date "MM/DD/YYYY",a_price,b_price,c_price,d_price)

Answer 1

To_number(char,’99999999.99999999)一下试试

Answer 2

能否将comb.csv截图看一下