title: Insert into a table values from another table using Oracle
body: <p>I have 2 tables ,</p>
  
  <p><strong>table 1</strong> has the following fields ,</p>
  
  <pre><code>u_id    id      no
  12      51      1
  21      51      2
  31      51      3
  41      51      4
  51      51      5
  61      51      6
  72      51      7
  81      51      8
  91      51      9
  92      51      10
  </code></pre>
  
  <p><strong>table 2</strong> has the following fields,</p>
  
  <pre><code>id      one     two     three   four    five    six     seven   eight   nine    ten
  
  51      12      21      31      41      51      61      72      81      91      92
  </code></pre>
  
  <p>I need to check the no. and the id from table 1 and insert the corresponding u_id into the table 2.</p>
  
  <p>for eg. if the id = 51 and the no is 1, then I have to insert the u-id value into the column one in table 2, </p>
  
  <p>and id = 51 and no = 2 then insert into column two and so on .. Please help . I am using Oracle.</p>