OPTIONS(ERRORS=-1,ROWS=100)
LOAD DATA
CHARACTERSET UTF8
INFILE '$INFILE'
BADFILE '$BADFILE'
APPEND INTO TABLE TB_E2E_CRM_ORDER
FIELDS TERMINATED BY '#@&@#'
trailing NULLCOLS
(
  ROW_ID,
  DATA_TYPE,
  CRM_ORDER_ID,
  CRM_ROW_NUM,
  VERSION_NUM,
  P6_ID,
  ORDER_CREATE_TIME "to_date(:ORDER_CREATE_TIME,'YYYY-MM-DD HH24:MI:SS')",
  ORDER_SUBMIT_TIME "to_date(:ORDER_SUBMIT_TIME,'YYYY-MM-DD HH24:MI:SS')",
  USER_NAME,
  USER_ADDRESS,
  DEVICE_NUM,
  DISTICT_BUREAU,
  PART_BUREAU,
  OPER_TYPE,
  OPER_SUB_TYPE,
  CLIENT_TYPE,
  PRODUCT_NAME,
  PRODUCT_NUM,
  SUBSCRIBE_TIME "to_date(:SUBSCRIBE_TIME,'YYYY-MM-DD HH24:MI:SS')",
  CRM_ROW_STATUS,
  LAST_UPDATE_TIME "to_date(:LAST_UPDATE_TIME,'YYYY-MM-DD HH24:MI:SS')",
  ORDER_STATUS,
  FILE_TIME "to_date('$FILE_TIME','YYYY-MM-DD HH24:MI:SS')"
)