간만에 작성한 SQL Loader

실행법

sqlldr id/password control=KB51_COL.CTL

 

[db1:/orabackup]$vi KB51_COL.CTL
"KB51_COL.CTL" 26 lines, 1165 characters
LOAD DATA
INFILE 'KB51_COL.LST'
BADFILE 'KB51_COL.BAD'
DISCARDFILE 'KB51_COL.DIS'
APPEND                  -- 추가로 삽입만 한다.
        INTO TABLE KB51_20090226
        fields terminated by ","
       (
                                    TELG_COM    CHAR(51),
                                    JOIN_NO    CHAR(15),
                                    JOIN_BSN_NO    CHAR(10),
                                    VCHR_CARD_ID    CHAR(16),
                                    APROV_NO    CHAR(8),
                                    APROV_DT    CHAR(8),
                                    SALE_DT    CHAR(8),
                                    PAY_DT    CHAR(8),
                                    SETTLE_AMT    CHAR(13),
                                    AGREE_AMT    CHAR(13),
                                    GOV_PAY_AMT    CHAR(13),
                                    INCM_TAX    CHAR(13),
                                    SOCI_TAX    CHAR(13),
                                    FEE    CHAR(13),
                                    CNCL_TP    CHAR(1),
                                    TX_GB    CHAR(1),
                                    VCHR_BLNC    CHAR(6) nullif VCHR_BLNC = blanks  -- 공백일경우 NULL로
        )