Oracle offers the FOR UPDATE clause of the SELECT statement to perform this ... Finally, you can append the optional keyword NOWAIT to the FOR UPDATE ...
docstore.mik.ua