title: Bulk Update from one table to another
body: <p>So I tried the bulk update in order to copy values from uemte_id column in pp_terminal table to uemte_id column (null at start) in mm_chip table. These two tables have no columns in common.This is what I used:</p>
  
  <pre><code>declare
    type ue_tab is table of  
              pp_terminal.uemte_id%type;
  
   ue_name ue_tab;
    cursor c1 is select uemte_id from pp_terminal;
  
  begin
   open c1;
  fetch c1 bulk collect into ue_name;
   close c1;
   -- bulk insert
  forall indx in ue_name.first..ue_name.last
     update mm_chip set uemte_id = ue_name(indx);
  
  end;
  / 
  </code></pre>
  
  <p>And this is the error message I get:</p>
  
  <pre><code>Error report:
  ORA-00001: unique constraint (DPOWNERA.IX_AK7_MM_CHIP) violated
  ORA-06512: at line 13
  00001. 00000 -  "unique constraint (%s.%s) violated"
  *Cause:    An UPDATE or INSERT statement attempted to insert a duplicate key.
             For Trusted Oracle configured in DBMS MAC mode, you may see
             this message if a duplicate entry exists at a different level.
  *Action:   Either remove the unique restriction or do not insert the key.
  </code></pre>
  
  <p>Do you see any obvious misstakes?</p>