Search code examples
oracle-databasetransactionscommitisolation-level

Can I change isolation level in Oracle?

I'm writting a transaction in Oracle. Can I change isolation level within this transaction for one select statement? Now I have Read Commit, and I want within transaction change this once to serializable and next back to the read commit.

Best Regards, Gregory

Solution

  • In SQL, you can use the SET TRANSACTION statement

    For example:

    set transaction isolation level serializable;  
set transaction isolation level read committed;