title: Query on FOR UPDATE NOWAIT in case of FK in Oracle
body: <p>I have a table <code>tab1 (t_id, status)</code> and table <code>tab2 (id, t_id, status)</code> where in <code>t_id.tab2</code> has Foreign Key reference to <code>tab1.t_id</code>.</p>
  
  <p>Assume an Oracle session s1 acquires <code>SELECT FOR UPDATE NOWAIT</code> lock on a record in <code>tab1</code> with <code>t_id=123</code>.</p>
  
  <p>While <code>NOWAIT</code> lock is still held by s1 on <code>tab1</code>, can another session s2 update record in <code>tab2</code> with <code>tab2.t_id=123</code> (FK)?</p>