| 1. | UPDATE statement can be used within PL/SQL programs to update a row or a set of rows | | |
| 2. | Select for update | | |
| 3. | Check row count being updating | | |
| 4. | Update with variable | | |
| 5. | Two UPDATE statements. | | |
| 6. | Check SQL%ROWCOUNT after updating | | |
| 7. | Exception handling for update statement | | |
| 8. | Update salary with stored procedure | | |
| 9. | Update table and return if success | | |
|
| 10. | Decrease salary with user procedure | | |
| 11. | Change price and output the result | | |
| 12. | Run an anonymous block that updates the number of book IN STOCK | | |
| 13. | Run an anonymous block that updates the number of pages for this book | | |
| 14. | Run the anonymous block to update the position column | | |
| 15. | Ajust price based on price range | | |
| 16. | Bundle several update and insert statements into one procedure | | |
| 17. | Use procedure to update table | | |