oracle外表

最新推荐文章于 2021-04-12 15:30:14 发布

超哥爱丫头

最新推荐文章于 2021-04-12 15:30:14 发布

阅读量589

点赞数

分类专栏：数据库

本文链接：https://blog.csdn.net/huchao660/article/details/54134219

版权

数据库专栏收录该内容

1 篇文章 0 订阅

订阅专栏

create table FTP_BD_PSNCL
(
createdate   CHAR(10),
dr           NUMBER(10) ,
memo         VARCHAR2(100),
pk_corp      CHAR(4),
pk_psncl     CHAR(20) ,
pk_psncl1    CHAR(20),
psnclasscode VARCHAR2(40) ,
psnclassname VARCHAR2(200) ,
psnclscope   NUMBER(38),
sealflag     CHAR(10),
ts           CHAR(19)
)
organization external
(
type ORACLE_LOADER
default directory FTP_DATASOURCE
access parameters
(
    RECORDS DELIMITED BY NEWLINE CHARACTERSET AL32UTF8
      BADFILE FTP_DATASOURCE:''BD_PSNCL.LOG''
      LOGFILE FTP_DATASOURCE:''BD_PSNCL.LOG''
      READSIZE 1048576
      FIELDS TERMINATED BY "     " RTRIM
      MISSING FIELD VALUES ARE NULL
      REJECT ROWS WITH ALL NULL FIELDS
      (

createdate   CHAR(10),
dr           NUMBER(10) ,
memo         VARCHAR2(100),
pk_corp      CHAR(4),
pk_psncl     CHAR(20) ,
pk_psncl1    CHAR(20),
psnclasscode VARCHAR2(40) ,
psnclassname VARCHAR2(200) ,
psnclscope   NUMBER(38),
sealflag     CHAR(10),
ts           CHAR(19)

)
)
location (FTP_DATASOURCE:''BD_PSNCL.TXT'')
)
reject limit UNLIMITED