我的表格式:
STOCKID number,
SDATE date,
SOPENPRICE number(5,2),
SMAXPRICE number(5,2),
SMINPRICE number(5,2),
SCLOSEPRICE number(5,2),
SVOLUMN number,
SAMOUNT number,
COMINFO blob,
INFOTRAP varchar2(2000)
csv数据格式为(一共800多条):
11-1月-07,9.89,10.31,9.83,10.31,40996055,599350528
12-1月-07,10.54,10.83,10.39,10.83,90902123,1399725056
15-1月-07,10.81,11.37,10.49,11.37,55236455,873682688
16-1月-07,11.51,11.95,11.51,11.88,52523640,893096128
17-1月-07,11.86,12.27,11.44,11.88,45910806,779058432
18-1月-07,11.83,11.95,11.28,11.29,48969519,801280768
19-1月-07,11.3,11.86,11.3,11.83,47932790,802892928
这7列是我想导入到表的:SDATE,SOPENPRICE,SMAXPRICE,SMINPRICE,SCLOSEPRICE,SVOLUMN,SAMOUNT字段。
请问控制文件该怎么写 ?
我这样写不行:
load data
infile 'c:\sz000001.csv'
append into table STOCK
fields terminated by ','
(
STOCKID FILLER,
SDATE,
SOPENPRICE,
SMAXPRICE,
SMINPRICE,
SCLOSEPRICE,
SVOLUMN,
SAMOUNT,
COMINFO FILLER,
INFOTRAP FILLER)
STOCKID number,
SDATE date,
SOPENPRICE number(5,2),
SMAXPRICE number(5,2),
SMINPRICE number(5,2),
SCLOSEPRICE number(5,2),
SVOLUMN number,
SAMOUNT number,
COMINFO blob,
INFOTRAP varchar2(2000)
csv数据格式为(一共800多条):
11-1月-07,9.89,10.31,9.83,10.31,40996055,599350528
12-1月-07,10.54,10.83,10.39,10.83,90902123,1399725056
15-1月-07,10.81,11.37,10.49,11.37,55236455,873682688
16-1月-07,11.51,11.95,11.51,11.88,52523640,893096128
17-1月-07,11.86,12.27,11.44,11.88,45910806,779058432
18-1月-07,11.83,11.95,11.28,11.29,48969519,801280768
19-1月-07,11.3,11.86,11.3,11.83,47932790,802892928
这7列是我想导入到表的:SDATE,SOPENPRICE,SMAXPRICE,SMINPRICE,SCLOSEPRICE,SVOLUMN,SAMOUNT字段。
请问控制文件该怎么写 ?
我这样写不行:
load data
infile 'c:\sz000001.csv'
append into table STOCK
fields terminated by ','
(
STOCKID FILLER,
SDATE,
SOPENPRICE,
SMAXPRICE,
SMINPRICE,
SCLOSEPRICE,
SVOLUMN,
SAMOUNT,
COMINFO FILLER,
INFOTRAP FILLER)
控制文件是:load data
infile 'c:\sz000001.csv'
append into table STOCK
fields terminated by ','
(
SDATE,
SOPENPRICE,
SMAXPRICE,
SMINPRICE,
SCLOSEPRICE,
SVOLUMN,
SAMOUNT)
infile 'c:\sz000001.csv'
append into table STOCK
fields terminated by ","
(sdate date 'dd-mon-yy',
SOPENPRICE,
SMAXPRICE,
SMINPRICE,
SCLOSEPRICE,
SVOLUMN,
SAMOUNT
)