"ID","EMAIL","PASSWORD","CONFPASSOWRD","SEX","USERNAME"
"206","[email protected]","86847wse","86847wse","2","杨雪莲"
"207","[email protected]","6741s2yi","6741s2yi","0","宋春雨"
"156","[email protected]","leisqiang","leisqiang","2","王颖"
"157","[email protected]","821s155","8211s55","2","林格格"OPTIONS (skip=1,rows=5) -- sqlldr 命令显示的选项可以写到这里边来,skip=1 用来跳过数据中的
LOAD DATA
INFILE "g://12.csv" --指定外部数据文件,可以写多个 INFILE "another_data_file.csv" 指定多个数据文件
append
INTO TABLE xgs_register
Fields terminated by "," -- 数据中每行记录用 "," 分隔
Optionally enclosed by '"' -- 数据中每个字段用 '"' 框起,比如字段中有 "," 分隔符时
trailing nullcols --表的字段没有对应的值时允许为空
(
id number,
EMAIL VARCHAR2(100),--邮箱
PASSWORD VARCHAR2(300),--密码
EMAILPASSOWRD VARCHAR2(30),--邮箱密码
SEX number,--性别
USERNAME VARCHAR2(30)--用户名)
执行报下面的错 G:\Documents and Settings\fuyou>sqlldr fuyou/fuyou control="g://xgs.ctl" log
="g://log.log"SQL*Loader: Release 9.2.0.1.0 - Production on 星期二 10月 13 10:57:48 2009Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.SQL*Loader-350: 语法错误位于第11行。
预期值是","或")",而实际值是"number"。
id number,
^
"206","[email protected]","86847wse","86847wse","2","杨雪莲"
"207","[email protected]","6741s2yi","6741s2yi","0","宋春雨"
"156","[email protected]","leisqiang","leisqiang","2","王颖"
"157","[email protected]","821s155","8211s55","2","林格格"OPTIONS (skip=1,rows=5) -- sqlldr 命令显示的选项可以写到这里边来,skip=1 用来跳过数据中的
LOAD DATA
INFILE "g://12.csv" --指定外部数据文件,可以写多个 INFILE "another_data_file.csv" 指定多个数据文件
append
INTO TABLE xgs_register
Fields terminated by "," -- 数据中每行记录用 "," 分隔
Optionally enclosed by '"' -- 数据中每个字段用 '"' 框起,比如字段中有 "," 分隔符时
trailing nullcols --表的字段没有对应的值时允许为空
(
id number,
EMAIL VARCHAR2(100),--邮箱
PASSWORD VARCHAR2(300),--密码
EMAILPASSOWRD VARCHAR2(30),--邮箱密码
SEX number,--性别
USERNAME VARCHAR2(30)--用户名)
执行报下面的错 G:\Documents and Settings\fuyou>sqlldr fuyou/fuyou control="g://xgs.ctl" log
="g://log.log"SQL*Loader: Release 9.2.0.1.0 - Production on 星期二 10月 13 10:57:48 2009Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.SQL*Loader-350: 语法错误位于第11行。
预期值是","或")",而实际值是"number"。
id number,
^
解决方案 »
- Oracle BIEE 数据显示缓慢问题
- ORACLE无法启动
- 在程序中创建存储过程的问题!
- 求存储过程与触发器(在线等待中……)
- (急)Oracle所在磁盘没有空间了,怎么办?
- : 小妹想向数据库方向发展,将来做个DBA,我该从什么方向去努力呢,还有该从什么什么样的职位做起发展更好啊。
- ORA-01658:无法为表空间SA中的段创建INITIAL区?
- 各位帮我看看这样的应用使用什么数据库比较好?
- Oracle9i中如何配置Directory Service?
- Oracle 8.1.7 安装后Enterprise Manager无法连接?帮帮忙!
- plsql中的不等于符号是否既可以用<>也可以用!=
- Toad for oracle中如何像PL/SQL一样直接编辑数据
你看看数据类型,估计是number
trailing nullcols --表的字段没有对应的值时允许为空
(
id number,
EMAIL VARCHAR2(100),--邮箱
PASSWORD VARCHAR2(300),--密码
EMAILPASSOWRD VARCHAR2(30),--邮箱密码
SEX number,--性别
USERNAME VARCHAR2(30)--用户名)
这是表的中的类型
ID NUMBER,
EMAIL VARCHAR2(100),
PASSWORD VARCHAR2(300),
EMAILPASSOWRD VARCHAR2(50),
SEX NUMBER,
USERNAME VARCHAR2(30),
LOAD DATA
INFILE "g://12.csv" --指定外部数据文件,可以写多个 INFILE "another_data_file.csv" 指定多个数据文件
append
INTO TABLE xgs_register
Fields terminated by "," -- 数据中每行记录用 "," 分隔
Optionally enclosed by '"' -- 数据中每个字段用 '"' 框起,比如字段中有 "," 分隔符时
trailing nullcols --表的字段没有对应的值时允许为空
(
id,
EMAIL,--邮箱
PASSWORD,--密码
EMAILPASSOWRD,--邮箱密码
SEX,--性别
USERNAME--用户名)
但我库里是varchar2 的,而它默认的是varchar 这对中文有影响吗
从导入表中的数据看,中文正常
update xgs_register set EMAIL=replace(EMAIL,' ','') ; --- 除去空格符