Differences

This shows you the differences between two versions of the page.

db2-to-oracle:select_isolation [April 24, 2013 1:43 am]
sqlines
db2-to-oracle:select_isolation [April 24, 2013 1:44 am] (current)
sqlines
Line 13: Line 13:
</code> </code>
-Oracle does not allow reading uncommitted rows and WITH UR clause should be removed from the SELECT statement. Often it is not a problem as WITH UR is mostly used to prevent any read locks in DB2, while in Oracle readers are never blocked.+Oracle does not allow reading uncommitted rows and WITH UR clause should be removed from the SELECT statement. Often it is not a problem as WITH UR is mostly used to prevent any read locks in DB2, while in Oracle readers are never blocked anyway.
WITH CS means to read committed rows, and this is the default in Oracle, so this clause can be also removed. WITH CS means to read committed rows, and this is the default in Oracle, so this clause can be also removed.