Question

如何用sqlload导字段类型是number的

Answer 1

load data
infile 'result.csv '
into table resultxt
(resultid number load data
infile 'result.csv '
into table resultxt
(resultid number terminated by ', ',
website char terminated by ', ',
ipport char terminated by ', ',
status char terminated by whitespace)
直接在ctl文件里面的字段后面标上number即可，否则自动转为Char。

追问

这样写问什么报错啊SQL*Loader-350: Syntax error at line 13.
Expecting valid column specification, "," or ")", found "number".
card_type number terminated by ', ',

追答

load data
infile 'result.csv '
into table resultxt
(resultid number load data
infile 'result.csv '
into table resultxt
FIELDS TERMINATED BY ','
(resultid number , website char ,ipport char , status char )
使用这个格式试一试

Answer 2

你先查询数据类型为number的，语句如下，你参考参考：
SELECT syscolumns.name FROM sysobjects INNER JOIN
syscolumns ON sysobjects.id = syscolumns.id INNER JOIN
systypes ON syscolumns.xtype = systypes.xtype where systypes.name ='number'
and sysobjects.name = '表名'
--如果还要模糊查询字段名，加上下面代码
-- and syscolumns.name like '%字段%'