Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> Sqlloader
Hallo,
I am running this sqlloader ctl-file
load data
infile 'C:\temp\arg\argdwfkt3.txt'
TRUNCATE
into table argdwfkt_kopia
FIELDS TERMINATED BY ';'
(BUTIKS_ID,
BUT_NAMN,
REGION_ID "DECODE(:REGION_ID,'!','98','?','97',:REGION_ID)",
DISTRIKT_ID "DECODE(:DISTRIKT_ID,'!','98','?','97',:DISTRICT_ID)",
ROLL_ID,
PROFIL_ID "DECODE(:PROFIL_ID,'!','98','?','97',:PROFIL_ID)",
AR,
KVARTAL,
MANAD,
VECKA,
DOKUMENTTEST_ARKFORMAT
"DECODE(:DOKUMENTTEST_ARKFORMAT,'A4','1','A3','2','E1','3','!','98','?','97','99')",
KAMPANJ_TYP,
MX_URVAL,
POSTBEFODRAN "DECODE(:POSTBEFODRAN,'A','1','B','2','!','98','?','97','99')",
PRINT_FORETAG_ID "DECODE(:PRINT_FORETAG_ID,'1','1','2','2','!','98','?','97','99')",
STYCKKOSTNAD,
FASTKOSTNAD_BREVMALL,
FASTKOSTNAD_ARENDE,
TOTAL_KOSTNAD, ANTAL_ÄRENDEN, ANTAL_BREVMALLAR_I_ARENDE, ANTAL_KUNDSEGMENT_I__ARENDE, ANTAL_KUNDER_I_URVAL, DATUM_HOS_KUND,
(See attached file: arg.log)
Thanks in advance
Roland S
=?iso-8859-1?Q?arg.log?=
Description: Binary data
Received on Tue Nov 13 2001 - 13:53:38 CST
![]() |
![]() |