GET TRANSACTION ISOLATION LEVEL

Description

You can assign the current isolation level to variable by using the GET TRANSACTION statement. The following is a statement that verifies the isolation level. variable.

Syntax

GET TRANSACTION ISOLATION LEVEL [ { INTO | TO } variable ] [ ; ]

Example

GET TRANSACTION ISOLATION LEVEL;

       Result

=============

  READ COMMITTED SCHEMA, READ UNCOMMITTED INSTANCES