I would like the ability to have the user update a quantity field on any or all of the rows and then hit an update button to update them.
COUNT UPDATE profile SET quotopurdays = people_tab(bulk Num). WHERE personid = people_tab(bulk Num); COMMIT; Oracle will not allow a FORALL update to use a PL table of records in the update as above etc..
My method of using FORALL to update many columns is by splitting a PL table of a string using SUBSTR in fixed places.
Hi Site Point members I have been perusing through the solutions for "updating multiple rows with one query", but I have a pressing question: How would one "SET" multiple column values with one query?
Here is my example..normal update command would be: // question ID ranges from 1-20 // $questionid == 1, $member_id==1 UPDATE table_Foo Bar SET answer One='$ans1Val', answer Two='$ans2Val', answer Three='$ans3Val' WHERE member_id='$memberid' AND question_id='$questionid'; // $questionid == 2, $member_id==1 UPDATE table_Foo Bar SET answer One='$ans1Val', answer Two='$ans2Val', answer Three='$ans3Val' WHERE member_id='$memberid' AND question_id='$questionid'; ..