APEX09.SQL01: Modify data. Use UPDATE & ROLLBACK commands and LOWER() & UPPER() functions.
If the http://db.kreie.net URL doesn't work, go to this website to access the scripts and other files used in this video series. https://sites.google.com/view/db-krei...
This video shows some variations in the UPDATE command with the WHERE clause and the use of functions, such as LOWER() and UPPER() to whether text is in upper or lowercase. The SQL commands ROLLBACK and SAVEPOINT, which can help undo an update error, are also shown.