title: Update a table based on a temporary table in oracle
body: <p>I want to update a column of a table(national_id from Personal_info) based on a value of a temporary table(nationalid from Tmp_Tbl).</p>
  
  <p>Below Two tables having a pk/fk relation with each other using cid,user_id.</p>
  
  <p><strong>Users(cid,user_name)</strong></p>
  
  <p><strong>Personal_info(user_id,national_id)</strong></p>
  
  <p>Temporary table also have a relation to Users table using user_name which is unique.</p>
  
  <p><strong>Tmp_Tbl(user_name,nationalid)</strong></p>
  
  <p>As it is oracle , i don't want to use of update join and also not merge syntax as i have the solution already.i am looking for a simple update query to use.</p>