sql语句小例子

merge into stkcode a
using (select * from stkcode t
where t.change_type='1')b
on (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;