ORA-01407: cannot update to null 错误解决

 update tb_test_log a
       set game_deal_log_id = (select game_deal_log_id
                         from test b
                        where a.table_id = b.table_id)
    where  exists (select 1 from test b where a.table_id=b.table_id);
参考：http://blog.itpub.net/7199859/viewspace-430077/