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.
[b]Question asked by visitor by Dhiraj[/b]
Re: I need to update huge amount of data into oracle database.
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.)