Hi,

Create 'Temp Table' and Load records from FlatFiles to this/these table using the SQL*Loader and then use the UPDATE statement from PL/SQL...if that's what you want..

Else you might want to look in to direct loading...using the 'directory' method..