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.
Diese Übung ist Teil des Kurses
Transactions and Error Handling in PostgreSQL
Interaktive Übung
Versuche dich an dieser Übung, indem du diesen Beispielcode vervollständigst.
-- 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
___;