ORACLE SQL.CTL 파일 문자열 잘라 insert 하기
LOAD DATA INFILE '파일명' insert INTO TABLE TRANSDATA ( pos_no POSITION(002:016), sale_date POSITION(017:024), sale_time POSITION(025:030), sale_no POSITION(031:042), access_yn POSITION(043:044), card_no POSITION(045:060), ori_sale_date POSITION(061:068), appr_no POSITION(069:078), appr_amt POSITION(079:090), service_amt POSITION(091:099), vat_amt POSITION(100:108), installment POSITION(109:110), c..
더보기