Update multiple values in Oracle (SQL) in one shot

[Dylan1]

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 mean, one query that updates everything)? I have the new information in Excel and I read it in a collection.

Thanks,

BD

[EmersonF]

Hi @Dylan1, Actually running this amount of lines, depending on your machine configuration, can be time consuming and costly (computationally speaking), I believe that it would be more viable to create an ETL process for cases like this, you have the file available in the X folder and the ETL process would consume and load it in bulk in the database, what do you think? I do something similar today using MS's SSIS Package​​

[Dylan1]

Hi @EmersonF, I think you may be right but I need a quick solution, that's why I need to solve this using Blue Prism, and then maybe improve it with ETL. Thanks, and please let me know if you know how can I do this​

[EmersonF]

@Dylan1, try it :
Extracting, Transforming and Loading Data (oracle.com)
i hope help you​