Sunday, July 20, 2008

oracle rownum with for update

this will be used in multithreading environment in oracle, can you see any issue?

SELECT rowid
FROM table tbl
WHERE tbl.col1 = 'U'
and tbl.col1 = 'abc'
and rownum <= 500
for update;

thanks.