Using rollbacks
Recently the FFIEC changed the reporting requirement for bank's that provide consumer deposit accounts if they have more than $5,000,000 in brokered deposits. Let's use a transaction to make that update safely. The "Provides Consumer Deposits" flag is in the RCONP752 column and the amount of brokered deposits is in the RCON2365 column.
This exercise is part of the course
Transactions and Error Handling in PostgreSQL
Hands-on interactive exercise
Have a go at this exercise by completing this sample code.
-- Begin a new transaction
___;
-- Update RCONP752 to true if RCON2365 is over 5000
UPDATE ffiec_reci
SET ___ = 'true'
WHERE ___ > 5000;
-- Oops that was supposed to be 5000000 undo the statement
___;