title: Oracle update table with the value from another database
body: <p>In one db i have table <code>PRODUCTS</code> with columns <code>NAME</code> and <code>TECHNICAL_NAME</code>.</p>
  
  <p>In second database I have table <code>TEMP_PRODUCTS</code> with columns <code>NAME</code> (that corresponds to column <code>NAME</code> of the table <code>PRODUCTS</code> from the 1st db) and <code>TECHNICAL_NAME</code> that is <code>null</code> and that should be updated with the corresponding <code>TECHNICAL_NAME</code> values from 1st db.</p>
  
  <p>So I should do <code>UPDATE table TEMP_PRODUCTS</code> by using <code>JOIN</code> with columns <code>NAME</code>?</p>
  
  <p>I would like to avoid solution with exporting table from 1st bd and importing it to the 2nd db.</p>
  
  <p>How can I do this?</p>