title: Oracle lock table with select statement
body: <p>with oracle 11g express, I do in 1st instance</p>
  
  <pre><code>LOCK TABLE mytab IN EXCLUSIVE MODE
  </code></pre>
  
  <p>then, I open a 2nd instance and I run</p>
  
  <pre><code>INSERT INTO mytable ...
  </code></pre>
  
  <p>It hangs, sounds cool,
  but a simple "SELECT * from mytable..." will not !?</p>
  
  <p>Why ?
  What is the correct way to "hang until" with the SELECT ?</p>
  
  <p>** update **
  Ok, I've seen this
  <a href="https://stackoverflow.com/questions/1487596/exclusive-table-read-lock-on-oracle-10g">Exclusive table (read) lock on Oracle 10g?</a></p>
  
  <p>So, my case is "lost" :) ?</p>