There are 4 types of transaction isolation levels. Here is the syntax :

SET TRANSACTION ISOLATION LEVEL

    { READ COMMITTED

        | READ UNCOMMITTED

        | REPEATABLE READ

        | SERIALIZABLE

    }

Once you set the Isolation level, it will work for that particular connection.

--Kishore