title: Updating Table Rows with another table data
body: <p>I have two tables I am trying to update table A data with table B. Table A (ids) has 100 rows (based on a condition) and I want to replace those ids with table B(ids). </p>
  
  <h1>Table A  </h1>                                
  
  <ul>
  <li>abc                                  </li>
  <li>def                                  </li>
  <li>klm                                  </li>
  <li>ijk </li>
  </ul>
  
  <h1>Table B </h1>
  
  <ul>
  <li>abc1234</li>
  <li>pknm </li>
  <li>lokimh </li>
  <li>2546njnh </li>
  </ul>
  
  <p>can you please provide me the SQL to replace these ids form table B to table A
  there are 100 rows which i need to update from table B to table A. </p>
  
  <pre><code>Cursor trans 
  select id 
  from table B 
  where rownnum &lt;=100 
  
  cursor user 
  select id 
  from table A
  </code></pre>