SQLLDR_TRIM

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

posted @ 2015-01-27 12:39  CoderLeob  阅读(661)  评论(0)    收藏  举报