ORA-30926: unable to get a stable set of rows in the source tables

SQL> Merge into tmp_mt p
  2  using mt_kh np
  3  on (p.mtname = np.mtname)
  4  When matched then
  5    update set p.mtjj = np.mtjj;
 
Merge into tmp_mt p
using mt_kh np
on (p.mtname = np.mtname)
When matched then
  update set p.mtjj = np.mtjj
 
ORA-30926: unable to get a stable set of rows in the source tables

 

 

需要确保np.mtname的唯一性，否则会报错