CODEWITHSUNDEEP
oracle11g
RedGuts
RedGuts

Reputation: 83

Oracle effect of SELECT FOR UPDATE on other SELECTs

Just like to know the result in the below scenario.

When we select a record using FOR UPDATE OF table.column_name.

What would be result set when another simple SELECT query runs to fetch the particular record which was locked by FOR UPDATE OF ?

Upvotes: 1

Views: 244

Answers (1)

Justin Cave
Justin Cave

Reputation: 231681

There would be no change. The simple SELECT statement would return the appropriate version of the row depending on the session's transaction isolation level and the SCN that it was reading data as of. The fact that some other session has locked the row has no impact on sessions running simple queries.

Upvotes: 1

Related Questions