One of the requirement we have encountered is to do batch upsert in oracle DB table.
While doing so we have come up with, first to sort the data into 2 list depending on whether the data is available in the target table or not. Then to batch insert the list of data which is not in the target table and to batch update the list of existing records.
But as you can see this is quite cumbersome. Do you think there is any other easy and straight forward way to do the same?