1.ORACLE加载TXT文本数据源
## 作者:付博
## 用途:ORACLE加载TXT文本数据源,加载效率高
Load data
infile 'C:\Users\ybzc_ranhua\Desktop\yukuaidaí\idp_data\idp_collect_info_20211031.txt' "str '@|@@^@'"
truncate
into table idp_collect info
fields terminated by '@|@'
optionally enclosed by '@^@'
TRAILING NULLCOLS
(
cus_id ,
cus_name ,
gendex ,
cus_tel ,
prod_name ,
branch_name ,
manager_name ,
manager_phone ,
cnt_days_recent ,
1f_contra_matured ,
th_total_repay ,
cur_dpd ,
hist_maxdpd ,
CLCT_SCORE ,
clct_group ,
if_msg_normal ,
if_mag_matrued ,
if_call_ivr ,
1f_call_manual ,
msg_content_cus CHAR(1024) ,
msg_content_manager CHAR(1024) ,
et1_datetime ,
data date
)