I want to create a stored procedure to execute multiple updates - around 50 - 100. I don't know the data or the ID before runtime. Do I pass in a list of id's and a list of values? If so how? Or do I iterate in code to call the update statement 100 times? like:
'execute update someValue someKey'
or just pass in lists
'execute update list(someValue) list(someKey)
or
execute update list(someKey, someValue)
UPDATE Table SET (column1 = 'someValue') WHERE column2 = 'someKey')
UPDATE Table SET (column1 = 'someValue') WHERE column2 = 'someKey')
UPDATE Table SET (column1 = 'someValue') WHERE column2 = 'someKey')