Row exclusive lock

[sajithamol]

Suppose one user write a query which will fetch huge number of rows from a table.Now when the query is trying to fetch nth to (n+t) number of rows ,at that time another user update some rows which are residing in between the nth and (n+t) number rows.Then what will happen to the query ,does it fetch those rows which are affected by update statement?

(Since update statement locks the rows from viewing and changing for the period of time the update statement is executing.)

[debasisdas]

the selection user will still select the records with out the effect of the commit till the second user commits the transaction