Oracle SQL: NOLOCK in join statment

sql oracle join locks read-uncommitted
Naren Karanam picture Naren Karanam · Jul 19, 2016 · Viewed 23.3k times · Source

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

Gary Myers picture Gary Myers · Jul 19, 2016

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.

Related questions

Oracle "(+)" Operator

I am checking some old SQL Statements for the purpose of documenting them and probably enhancing them. The DBMS is Oracle I did not understand a statement which read like this: select ... from a,b where a.id=b.id(+) …

Read More
Difference between Oracle's plus (+) notation and ansi JOIN notation?

What's the difference between using oracle's plus notation (+) over the ansi standard join notation? Is there a difference in performance? Is the plus notation deprecated?

Read More
SQL join subquery

I tried searching for an answer to my problem but failed to get an answer that actually helped. I've written an sql code but can't seem to find where the problem is. Is it possible to put a subquery in …

Read More