title: update query result not reflecting in table
body: <p>I have two tables <code>test1</code> and <code>test2</code>. What I need is, I would like to update one column in the table <code>test2</code> with data from the table <code>test1</code>. My query is</p>
  
  <pre><code> UPDATE test2 t2 
      SET t2.name = (SELECT t1.name 
                       FROM test1 t1 
                      WHERE t1.id = t2.mob)
    WHERE t2.mob IN (SELECT t1.id 
                       FROM test1 t1 
                      WHERE t1.id = t2.mob) 
  </code></pre>
  
  <p>It's showing <code>3 Rows updated</code> , But It's not reflecting in my table. My <a href="https://stackoverflow.com/questions/7030699/oracle-sql-update-with-data-from-another-table">reference</a>. Is there any issue in my query. Or what should I do alternately.</p>
  
  <p><img src="https://i.stack.imgur.com/4lb3b.png" alt="enter image description here"></p>