a SELECT FOR UPDATE question

[Tim Vadnais <tvadnais@xxxxxxxx>]

Title: a SELECT FOR UPDATE question

Hi,

If I select a row for update, is there anyway that someone can query to see if that row has been 'selected for update' and by whom?

Then I'd like to know if the session that 'SELECT(ed) FOR UPDATE' dies, will the server release the locked row?

Thank you,

tvadnais