Thanks Chris,

To all:

What is the purpose of the 'select for update clause' ? Just to be able to lock the rows ?

If so, then do you have to issue a commit after the 'select for update clause' - is that the only way ?