Search code examples
sqloraclejoinlocksread-uncommitted

Oracle SQL: NOLOCK in join statment

I can not use NOLOCK after table names in join statements. Is it even a valid scenario to try to read uncommitted data over JOINs

Solution

  • The join is irrelevant. NOLOCK isn't used in Oracle. A query will only see committed data (plus any uncommitted changes in the transaction performing the query).

    You can write a query such as SELECT * FROM tbl NOLOCK but NOLOCK is simply being used as a table alias and doesn't change the querying mechanism.