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

浙公网安备 33010602011771号