Re: SQLLoader ?

SQL*Loader allows you to read a text file and insert/update into an existing table. It also creates an error file that you specify and a bad file of records it could not insert for one reason or another. It is very limited as to parsing the file. SQL*Loader can be a real pain (especially if you want it to do something it just plain can't do....). There are some rules and formatting you can do however if you need to do substantial modification of the data (If value = 'Yes' or 'yes' or 'YES' then insert 'Y') then I recommend creating what I call a generic table (cola - colz of type varchar(255)), insert the whole text file into there and then process it accordingly using procedures.

Regards,
Ken Colerick
colerick_at_rl.af.mil Received on Mon Oct 26 1998 - 15:59:15 CET