topic Re: Update multiple values in Oracle (SQL) in one shot in Product Forum

Update multiple values in Oracle (SQL) in one shot

Dylan1 — Mon, 19 Jul 2021 19:09:31 GMT

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

Re: Update multiple values in Oracle (SQL) in one shot

EmersonF — Tue, 20 Jul 2021 01:47:30 GMT

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

Re: Update multiple values in Oracle (SQL) in one shot

Dylan1 — Tue, 20 Jul 2021 03:20:57 GMT

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

Re: Update multiple values in Oracle (SQL) in one shot

EmersonF — Tue, 20 Jul 2021 12:15:42 GMT

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