Does anybody have specific info on row locking in Oracle

Argo

Lifer
Apr 8, 2000
10,045
0
0
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?