Sql Loader (sqlldr/SqlLoader)

launch
    
sqlldr USER/PWD control=Temp_load.ctl log=Temp_load.log

 

ctl example

LOAD DATA
   INFILE 'TempPOFromPayinfoPO.csv'
   INSERT INTO TABLE ALDO.TMP_TEMP_PO
   FIELDS TERMINATED BY "," OPTIONALLY ENCLOSED BY '"'
   TRAILING NULLCOLS
   (CLIENTE, FLG)

 

csv example

...
0000032,2
0000041,2
0000044,1
...