title: Is there a way to select records from Oracle and lock them to avoid being read by another request?
body: <p>I have a java based webservice (REST API) that needs to read records from a table in Oracle DB. There is a possibility that 2 requests may be fired to that API at the same time thereby leading to same records being selected by both the requests for processing. </p>
  
  <p>How to avoid this issue? Oracle allows only select and I dont know how we can efficiently lock records?</p>