Additionally if you forget the WHERE clause altogether, you will update the entire table when you might not intend to.
Here is an example where I specified the WHERE clause incorrectly and I updated too many rows: Here I updated Toy Name on two rows, the “Silver Magic” and the “Super Surfer” Toyname rows.
After each exercise, we provide the solution so you can check your answer.
i am trying to update the 2 colums of a table based on the cursor result set with key values are matching.
These exercises allow you to try out your skills with the UPDATE statement.