merge into stkcode ausing (select * from stkcode twhere t.change_type='1')bon (a.id=b.id and a.stock_code=b.stock_code)update set a.change_type=b.change_type||',2'where a.change_type='1';commit;
?