I need to know how does oracle handle "select * from ... order by xxx for update"
Two questions:
1) Is the locking atomic or does oracle handle it one row at a time.
2) If it's handled row at a time - does oracle honor the order by before or after locking?