Исходный код вики Примеры.
Версия 1.1 от Alexandr Fokin на 2023/01/08 19:06
Скрыть последних авторов
| author | version | line-number | content |
|---|---|---|---|
 |
1.1 | 1 | |(% style="width:272px" %)Необходимый уровень изоляции|(% style="width:1191px" %) |
| 2 | |(% style="width:272px" %)Read Committed Isolation Level|(% style="width:1191px" %){{code language="none"}}BEGIN; | ||
| 3 | |||
| 4 | UPDATE accounts SET balance = balance + @payment WHERE acctnum = @account1 | ||
| 5 | UPDATE accounts SET balance = balance - @payment WHERE acctnum = @account; | ||
| 6 | |||
| 7 | COMMIT;{{/code}} | ||
| 8 | |(% style="width:272px" %)Read Committed Isolation Level|(% style="width:1191px" %){{code language="none"}}BEGIN; | ||
| 9 | |||
| 10 | if (SELECT balance FROM accounts where acctnum = 7534) < @payment | ||
| 11 | RAISE EXCEPTION '' | ||
| 12 | END IF | ||
| 13 | |||
| 14 | UPDATE accounts SET balance = balance + @payment WHERE acctnum = 12345; | ||
| 15 | UPDATE accounts SET balance = balance - @payment WHERE acctnum = 7534; | ||
| 16 | |||
| 17 | COMMIT;{{/code}} | ||
| 18 | |||
| 19 |