Here is an excerpt from Oracle Doc re. the select for update clause:

"locks the selected rows so that other users cannot lock or update the rows until you end your transaction. You can specify this clause only in a top-level SELECT statement (not in subqueries)."


When is the lock removed? By 'end your transaction' do they mean when the select is over ???

Thanks in advance.