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.
Watch video APEX09.SQL01: Modify data. Use UPDATE & ROLLBACK commands and LOWER() & UPPER() functions. online without registration, duration hours minute second in high quality. This video was added by user J Kreie Database 10 October 2018, don't forget to share it with your friends and acquaintances, it has been viewed on our site 1,260 once and liked it 3 people.