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),

card_in_fg POSITION(111:111),

issuer POSITION(112:115),

acquirer POSITION(116:119),

affiliation POSITION(120:134),

af_business_no POSITION(135:144),

appr_proc_fg POSITION(145:145),

foreign_yn POSITION(146:146),

check_yn POSITION(147:147)

)