CODEWITHSUNDEEP
oracle-databasetransactionscommitisolation-level
GrzesiekO
GrzesiekO

Reputation: 1199

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

Upvotes: 2

Views: 6151

Answers (1)

Rob van Wijk
Rob van Wijk

Reputation: 17705

In SQL, you can use the SET TRANSACTION statement

For example:

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

Upvotes: 9

Related Questions