driver_tmp.ctl

Oracle资料大集合

LOAD DATA 
INFILE 'INFILE/driver_tmp.DAT' " str '|\r\n'" 
APPEND
INTO TABLE driver_tmp
(
N_JSYBH                        POSITION(1:16) DECIMAL EXTERNAL NULLIF N_JSYBH=BLANKS ,
C_JSZZL_DM                     POSITION(17:32) CHAR NULLIF C_JSZZL_DM=BLANKS ,
C_GZKZJ                        POSITION(33:58) CHAR NULLIF C_GZKZJ=BLANKS ,
C_JSZH                         POSITION(59:76) CHAR NULLIF C_JSZH=BLANKS ,
C_DABH                         POSITION(77:94) CHAR NULLIF C_DABH=BLANKS ,
C_XM                           POSITION(95:144) CHAR NULLIF C_XM=BLANKS ,
C_XB_DM                        POSITION(145:160) CHAR NULLIF C_XB_DM=BLANKS ,
D_CSRQ                         POSITION(161:179) DATE 'yyyy-mm-dd hh24:mi:ss' NULLIF D_CSRQ=BLANKS ,
C_DJZZXZQH                     POSITION(180:195) CHAR NULLIF C_DJZZXZQH=BLANKS ,
C_DJZZ                         POSITION(196:323) CHAR NULLIF C_DJZZ=BLANKS ,
C_XZZXZQH                      POSITION(324:339) CHAR NULLIF C_XZZXZQH=BLANKS ,
C_XZZ                          POSITION(340:467) CHAR NULLIF C_XZZ=BLANKS ,
C_LSZZXZQH                     POSITION(468:483) CHAR NULLIF C_LSZZXZQH=BLANKS ,
C_LSZZ                         POSITION(484:611) CHAR NULLIF C_LSZZ=BLANKS ,
D_CCLZRQ                       POSITION(612:630) DATE 'yyyy-mm-dd hh24:mi:ss' NULLIF D_CCLZRQ=BLANKS ,
C_ZJCX_DM                      POSITION(631:650) CHAR NULLIF C_ZJCX_DM=BLANKS ,
D_JSZQSRQ                      POSITION(651:669) DATE 'yyyy-mm-dd hh24:mi:ss' NULLIF D_JSZQSRQ=BLANKS ,
D_JSZZZRQ                      POSITION(670:688) DATE 'yyyy-mm-dd hh24:mi:ss' NULLIF D_JSZZZRQ=BLANKS ,
C_FZJG_DM                      POSITION(689:704) CHAR NULLIF C_FZJG_DM=BLANKS ,
D_ZJNSRQ                       POSITION(705:723) DATE 'yyyy-mm-dd hh24:mi:ss' NULLIF D_ZJNSRQ=BLANKS ,
C_JSZZT_DM                     POSITION(724:739) CHAR NULLIF C_JSZZT_DM=BLANKS ,
N_WZFZ                         POSITION(740:741) DECIMAL EXTERNAL NULLIF N_WZFZ=BLANKS ,
C_XZQH_DM                      POSITION(742:757) CHAR NULLIF C_XZQH_DM=BLANKS ,
D_FZRQ                         POSITION(758:776) DATE 'yyyy-mm-dd hh24:mi:ss' NULLIF D_FZRQ=BLANKS ,
C_JSYLY_DM                     POSITION(777:792) CHAR NULLIF C_JSYLY_DM=BLANKS ,
C_GJ_DM                        POSITION(793:808) CHAR NULLIF C_GJ_DM=BLANKS ,
C_SFZJZL_DM                    POSITION(809:824) CHAR NULLIF C_SFZJZL_DM=BLANKS ,
C_ZZZHM                        POSITION(825:842) CHAR NULLIF C_ZZZHM=BLANKS ,
C_JLZHM                        POSITION(843:860) CHAR NULLIF C_JLZHM=BLANKS ,
C_DH                           POSITION(861:880) CHAR NULLIF C_DH=BLANKS ,
C_YB                           POSITION(881:886) CHAR NULLIF C_YB=BLANKS ,
N_ZYYFZY                       POSITION(887:887) DECIMAL EXTERNAL NULLIF N_ZYYFZY=BLANKS ,
N_SG                           POSITION(888:890) DECIMAL EXTERNAL NULLIF N_SG=BLANKS ,
C_SL                           POSITION(891:910) CHAR NULLIF C_SL=BLANKS ,
C_BS                           POSITION(911:930) CHAR NULLIF C_BS=BLANKS ,
C_TL                           POSITION(931:950) CHAR NULLIF C_TL=BLANKS ,
C_STYDNL                       POSITION(951:970) CHAR NULLIF C_STYDNL=BLANKS ,
C_YWFA                         POSITION(971:990) CHAR NULLIF C_YWFA=BLANKS ,
C_GJJZZH                       POSITION(991:1008) CHAR NULLIF C_GJJZZH=BLANKS ,
D_GJJZFZRQ                     POSITION(1009:1027) DATE 'yyyy-mm-dd hh24:mi:ss' NULLIF D_GJJZFZRQ=BLANKS ,
C_GJJSZFZJG_DM                 POSITION(1028:1043) CHAR NULLIF C_GJJSZFZJG_DM=BLANKS ,
C_BZ                           POSITION(1044:1243) CHAR NULLIF C_BZ=BLANKS ,
C_BLZD1                        POSITION(1244:1263) CHAR NULLIF C_BLZD1=BLANKS ,
C_BLZD2                        POSITION(1264:1283) CHAR NULLIF C_BLZD2=BLANKS ,
C_BLZD3                        POSITION(1284:1303) CHAR NULLIF C_BLZD3=BLANKS ,
C_BLZD4                        POSITION(1304:1323) CHAR NULLIF C_BLZD4=BLANKS ,
C_BLZD5                        POSITION(1324:1343) CHAR NULLIF C_BLZD5=BLANKS ,
ACTION_J                       POSITION(1344:1443) CHAR NULLIF ACTION_J=BLANKS ,
STATUS_J                       POSITION(1444:1543) CHAR NULLIF STATUS_J=BLANKS ,
DOTIME_J                       POSITION(1544:1643) CHAR NULLIF DOTIME_J=BLANKS )