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

57 votes470 views6 answers
Sql alter table
SQL
1 vote231 views1 answer
Oracle compile schema
SQL
2 votes314 views1 answer
How to find table table in stored procedure sql server
SQL
0 vote298 views4 answers
Stored procedure sql
SQL
0 vote342 views1 answer
Sql datum formatieren
SQL
0 vote290 views1 answer
Start and stop mysql
SQL
6 votes302 views1 answer
Oracle rank
SQL
17 votes306 views4 answers
Mysql remove ubuntu
SQL
0 vote309 views1 answer
Running mysql from bash sc
SQL
0 vote297 views1 answer
Sql script to get a type task on jira datbase for 12 months
SQL