当前位置: 代码迷 >> 综合 >> CSV文本数据如何导入oracle(实例)
  详细解决方案

CSV文本数据如何导入oracle(实例)

热度:76   发布时间:2024-01-18 16:04:35.0

 1。XAMSHAIN.bat

sqlldr  user/password@nsrt control=XAMSHAIN.ctl          data=XAMSHAIN.csv log=XAMSHAIN.log          bad=XAMSHAIN.bad skip=3
pause

2。XAMSHAIN.ctl

load data
infile *
into table XAMSHAIN
truncate
fields terminated by "," optionally enclosed by "'"
trailing nullcols
(
SHIMEI_CD,
VALID_TERM_START_YMD,
SHAIN_NMJ_SEI,
SHAIN_NMJ_NA,
SHAIN_NMHK_SEI,
SHAIN_NMHK_NA,
SHAIN_NMHE_SEI,
SHAIN_NMHE_MIDDLE,
SHAIN_NMHE_NA,
SEI_BETSU_KBN,
BIRTH_DAY,
SAIYOU_YMD,
KEI_BETSU_CD,
RETIRE_YMD,
BANK_CD,
BANK_NMJ,
BANK_NMK,
BANK_SHITEN_CD,
BANK_SHITEN_NMJ,
BANK_SHITEN_NMK,
YOKIN_TYPE,
KOUZA_MEIGI_KANA,
KOUZA_NO,
SSO_TAISHO_FLG,
VALID_TERM_END_YMD,
NEXT_SYSTEM_TAISHO_FLG,
IDOU_F