Update multiple values in Oracle (SQL) in one shot

Dylan

New Member
Hello everyone,

I need to update 10k rows and 100 columns daily in Oracle. It's too slow if I do it using a loop over the collection that contains the new values. Is there any way to do it in one shot? I have the new information in Excel and I read it in a collection.

Thanks,

BD
 

sahil_raina_91

Active Member
Hello everyone,

I need to update 10k rows and 100 columns daily in Oracle. It's too slow if I do it using a loop over the collection that contains the new values. Is there any way to do it in one shot? I have the new information in Excel and I read it in a collection.

Thanks,

BD
Haven't tried it myself, but here are some references that maybe helpful :
 
Top