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.
Bu egzersiz
Transactions and Error Handling in PostgreSQL
kursunun bir parçasıdırUygulamalı interaktif egzersiz
Bu örnek kodu tamamlayarak bu egzersizi bitirin.
-- 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
___;