Transaction Isolation Level

[cbandy]

The SQL-92 standard allows the isolation level of the next transaction to be specified.

The most common implementation is to set the isolation level of all subsequent transactions. The syntax for this was standardized in SQL:1999 as SET SESSION CHARACTERISTICS ..., though most vendors don't care.

MySQL: SET SESSION TRANSACTION ISOLATION LEVEL {level};
Oracle: ALTER SESSION SET ISOLATION_LEVEL = {level};
PostgreSQL: SET SESSION CHARACTERISTICS AS TRANSACTION {level};
SQL Server: SET TRANSACTION ISOLATION LEVEL {level};
SQLite: PRAGMA read_uncommitted = 1;

[Yahasana]

👍