In Progress

Oracle DBA to rewrite SP handle Upsert batches

We have a Stored Procedure today that upserts row by row from a Logic App. Its very inefficient since if its 50.000 rows it does 50.000 requests to the DB.

Instead we would like to be able to send the whole batch to the Stored Procedure and let it insert these in a more efficient way.

Skills: Oracle, Database Administration, Database Development

About the Employer:
( 8 reviews ) Saltsjöbaden, Sweden

Project ID: #21355975

Awarded to:

pterik

Hi. My name Vitaly, I'm a developer from Ukraine. I work as an outsource database developer last 5 years, and you may look at my profile on [login to view URL] (/in/makhaev) Also, I worked as Oracle DBA for Miratex company More

$90 USD in 4 days
(0 Reviews)
0.0

5 freelancers are bidding on average $126 for this job

truongnguyen86

Hello there, i'm expert on database technology with over 9 years experiences, to insert batch we need first to select those data need to be inserted(updated or deleted). Then after we will Insert by bulk(Updated or Del More

$250 USD in 2 days
(136 Reviews)
6.7
blackwhite123

Hello, I am pleasure with your job for . Thank you for the job posting. It’s a pleasure to meet you. I’d really like to work with you on this one if possible! I do have a couple of questions, but first I’d like to make More

$140 USD in 7 days
(0 Reviews)
0.0
chenmingbiz

Hi, I have rich experiences in Oracle, MySQL and I am very familiar with SP. I can complete your project in a short time and start right now for you. I would like to have more detailed discussion with you via chat. Tha More

$100 USD in 2 days
(0 Reviews)
0.0
LoveHeart1

Hi, Nice to meet you! I am very interesting your project and I am confident of I can help your job. I am confident of this project as I'm a professional Oracle database with over 7 years of experience. Seems to be an i More

$50 USD in 7 days
(0 Reviews)
0.0