Differences

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

oracle-to-mysql:skip_locked [March 03, 2013 3:02 pm]
sqlines
oracle-to-mysql:skip_locked [March 03, 2013 3:04 pm] (current)
sqlines
Line 58: Line 58:
Note the second session did not select a task as //rownum// counts **locked** and **unlocked** rows. {{:exclamation.png|}} Note the second session did not select a task as //rownum// counts **locked** and **unlocked** rows. {{:exclamation.png|}}
-So in Oracle you cannot use //rownum = 1// to select tasks one by one in multiple concurrent sessions, and typically you have to use a cursor and specify a large //rownum// limit to select rows:+So in Oracle you cannot use //rownum = 1// to select tasks one by one in multiple concurrent sessions, and typically you have to use a cursor and specify a larger //rownum// limit to select rows:
**Oracle** (Session 2): **Oracle** (Session 2):