title: Getting correct auto incremented ID in Oracle DB
body: <p>I am inserting one row into the ORACLE database table, where the 
  primary key ID is autoincrement.
  and
  I am retriving the autoincremented ID from that TABLE.</p>
  
  <p>In case of many people using the same TABLE.
  I may run into the consumer producer problem where I may
  get ID of other user.</p>
  
  <p>Some of user on SO mentioned about getting these incremented ID
  is based on the <a href="https://stackoverflow.com/questions/3707653/database-how-to-prevent-from-getting-wrong-id">connection</a> which will not result in Consumer Producer
  problem: </p>
  
  <p>Just want to check below things with SO: </p>
  
  <p><strong>First:</strong></p>
  
  <p>Will I get exact autoincremented ID from below sceneario:</p>
  
  <pre><code>1) Two computer with in different subnet using DB.
  2) Two computer wiht in same subnet using DB.
  3) Two process using using DB connection.
  4) Two thread uisng DB connection.
  </code></pre>
  
  <p><strong>Second</strong>:</p>
  
  <pre><code> If my insert is:
   Insert into Tables (ID,NAME,DESCRIPTION) values (DBNull,'Name','Description');
  
   What should be my query to get the autoincremented ID generated for above
   Insert.
  
  C# related command will do much help :)
  </code></pre>