Dbms transaction (psql)

BEGIN;
UPDATE accounts SET balance = balance - 100.00
    WHERE name = 'Alice';
SAVEPOINT my_savepoint;
UPDATE accounts SET balance = balance + 100.00
    WHERE name = 'Bob';
-- oops ... forget that and use Wally's account
ROLLBACK TO my_savepoint;
UPDATE accounts SET balance = balance + 100.00
    WHERE name = 'Wally';
COMMIT;

Source: postgresql.org

Similar codes

1 vote166 views1 answer
Floor function in sql oracle
SQL
0 vote169 views1 answer
How to connect pgadmin with excel
SQL
0 vote186 views1 answer
The report definition has an invalid target namespace 'http://schemas.microsoft.com/SQLServer/reporting/reportdesigner'
SQL
4 votes170 views1 answer
Invalid reference to FROM-clause entry for table "unidades
SQL
1 vote174 views3 answers
Rename table snowflake
SQL
9 votes179 views3 answers
Oracle undo usage by session
SQL
0 vote180 views1 answer
Sql server query database space available
SQL
-1 vote133 views1 answer
Mysql how to set update or create
SQL
6 votes224 views2 answers
Oracle compile trigger
SQL
1 vote145 views2 answers
Procedure pl/sql
SQL