Locking by using FOR UPDATE

Hi!

I'm working with Oracle 7.0. If an application locks a row and another one tries to lock a set of rows (by using SELECT FOR UPDATE, let's say) and suppose that the locked row belongs to the selected set... will the second application receive any data from the server while the first application still holds the lock over the row? Is there any way to achieve that? I mean, I need to know if a certain row is locked, but I would like to get the other rows. I need to do this by using SQL, but any idea will be welcome.

Thanks,
Mariana.

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Tue Dec 29 1998 - 08:34:55 CST