hncys 发表于 2018-9-21 13:26:09

sqlldr导入oracle数据

  (r sequence(max,1),
  sheet_id,
  sheet_type,
  sheet_class,
  cust_type,
  visit_type,
  ans_type,
  ans_type_info,
  call_num,
  busi_num,
  busi_num_type,
  cust_name,
  apply_cust,
  link_cust,
  link_phone1,
  link_phone2,
  accept_info char(1000),
  accept_type,
  bb FILLER,
  opt_date DATE 'YYYY-MM-DD HH24:MI:SS',
  reply_date DATE 'YYYY-MM-DD HH24:MI:SS',
  opt_user,
  opt_group,
  second_accept,
  last_sheet_id,
  hard_accept,
  callback_flag,
  status CONSTANT 2,
  status_old,
  CALL_CODE CONSTANT 0,
  accept_level CONSTANT 1,
  quest_accept CONSTANT 1,
  opt_dept CONSTANT 'AA'
  )

页: [1]
查看完整版本: sqlldr导入oracle数据