-- sqlldr userid=dev/dev control=c:\load\demo07.ctl log=c:\load\demo07.log LOAD DATA INFILE * INSERT INTO TABLE funcdemo ( LAST_NAME position(1:7) CHAR "UPPER(:LAST_NAME)", FIRST_NAME position(8:15) CHAR "LOWER(:FIRST_NAME)" ) BEGINDATA Poder Tanel Wilton Jeremiah