通过其它两个表的关系,来 更新某一个表的一个字段值,
sql 代码
- CREATE OR REPLACE PROCEDURE proc_updateuser_region is
- cursor region_cur is
- select c.id, b.segment
- from co2segment b ,co2_region c
- where b.regionid = c.id;
- begin
- for my_cur in region_cur loop
- update co2user
- set region_id=my_cur.id
- where region_id is null and msisdn like SUBSTR(my_cur.segment, 0, 7)||'%';
- commit;
- end loop;
- end ;