SQLLDR_加载oracle文本数据源

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
)
posted @ 2022-03-06 19:17  付十一。  阅读(36)  评论(0)    收藏  举报