CREATE TABLE GL_POINT

(

  UNIT_ID        VARCHAR2(20 BYTE),

  DEPT_ID        VARCHAR2(20 BYTE),

  ZHJGDM         VARCHAR2(6 BYTE),

  STAT_DATE      DATE,

  ADD_POINT      INTEGER

 )

000000              |+|000001              |+|000000|+|24-JUL-10   |+| 154169934

2270                |+|000002              |+|7889  |+|24-JUL-10   |+|       100

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)"

 )

sqlldr username/password data=gl_point.dat control=gl_point.ctl log=gl_point.log bad=gl_point.bad