sql 取代游标的写法示例
程序员文章站
2023-11-30 10:41:28
update tb_garden1 g set steward = (
select id from zyq.tb_user u where replace(u....
update tb_garden1 g set steward = ( select id from zyq.tb_user u where replace(u.name, '区') = g.name and rownum =1) where exists (select 1 from zyq.tb_user u where replace(u.name, '区') = g.name and rownum = 1)