title: ORACLE PL/SQL: Testing SELECT FOR UPDATE in Oracle SQL Developer
body: <p>We are currently trying to implement a SELECT FOR UPDATE in order to lock rows. If I run:</p>
  
  <pre><code>SELECT * FROM data where rowid = 'AAAQA5AAGAACNbEAA1' FOR UPDATE;
  SELECT * FROM data where rowid = 'AAAQA5AAGAACNbEAA1' FOR UPDATE NOWAIT;
  </code></pre>
  
  <p>I get nothing back in ORACLE SQL Developer. Isn't this supposed to throw me an error? Does this have something to do with using the same user id? </p>