Thread: I need to update huge amount of data into oracle database.

I need to update huge amount of data into oracle database. I want to do it through script. In that script it will take new data from a flat file (abc.txt) and run the update query and will update the database. How shall i do it?Pls help me ASAP.

Question asked by visitor by Dhiraj

To load data from flat file you can use SQL LOADER .

for this the flat file format should be .CSV (ucan also use .txt files but CSV is recommended.)