Oracle SQL: NOLOCK in join statment

Question

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

Answer 1

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.