Single statement transactions
Now you will work with a single statement transaction. Some types of saving accounts hold money that cannot be withdrawn on demand for individuals and corporations. The amount of the heldback money is stored in the RCONB550 field. These types of accounts promote bank stability and generate dependable revenue for the financial institution via fees and loan proceeds. Let's update FIELD48 to be '1' for each of these institutions to signify that they have this stability when it's over $100M.
Este exercício faz parte do curso
Transactions and Error Handling in PostgreSQL
Exercício interativo prático
Experimente este exercício completando este código de exemplo.
-- Update records to indicate nontransactionals over 100,000,000
UPDATE ffiec_reci
SET ___ = '___'
WHERE RCONB550 > ___;
-- Select a count of records where the flag field is not '1'
SELECT COUNT(*)
FROM ffiec_reci
WHERE ___ != ___ or ___ is null;