Discarding Changes
Sheila needs to make changes to the EMPOYEES table to change the data for certain employees. She uses the transactional mode in SQL Command interface to perform these changes. While issuing the UPDATE command, she accidentally omits the WHERE clause, thereby causing the entire table to be affected. Because she is in transactional mode, her changes have not been saved automatically. She issues a ROLLBACK statement to undo the changes.
Watch Sheila use ROLLBACK to fix her errors.
 |