1. 建表语句
CREATE TABLE GL_POINT
(
UNIT_ID VARCHAR2(20 BYTE),
DEPT_ID VARCHAR2(20 BYTE),
ZHJGDM VARCHAR2(6 BYTE),
STAT_DATE DATE,
ADD_POINT INTEGER
)
2. 数据文件内容
000000 |+|000001 |+|000000|+|24-JUL-10 |+| 154169934
2270 |+|000002 |+|7889 |+|24-JUL-10 |+| 100
3. ctl文件内容
load data
into table GL_POINT truncate
--into table GL_POINT truncate when unit_id <>'' 不导入unit_id为空的数据
fields terminated by '|+|' TRAILING NULLCOLS
( --字段名称
UNIT_ID "trim(:UNIT_ID)",
DEPT_ID "trim(:DEPT_ID)",
ZHJGDM "trim(:ZHJGDM)",
STAT_DATE "trim(:STAT_DATE)",
ADD_POINT "trim(:ADD_POINT)"
CREATE TABLE GL_POINT
(
UNIT_ID VARCHAR2(20 BYTE),
DEPT_ID VARCHAR2(20 BYTE),
ZHJGDM VARCHAR2(6 BYTE),
STAT_DATE DATE,
ADD_POINT INTEGER
)
2. 数据文件内容
000000 |+|000001 |+|000000|+|24-JUL-10 |+| 154169934
2270 |+|000002 |+|7889 |+|24-JUL-10 |+| 100
3. ctl文件内容
load data
into table GL_POINT truncate
--into table GL_POINT truncate when unit_id <>'' 不导入unit_id为空的数据
fields terminated by '|+|' TRAILING NULLCOLS
( --字段名称
UNIT_ID "trim(:UNIT_ID)",
DEPT_ID "trim(:DEPT_ID)",
ZHJGDM "trim(:ZHJGDM)",
STAT_DATE "trim(:STAT_DATE)",
ADD_POINT "trim(:ADD_POINT)"