update dept d set d.dept_name=(select 'B2 '||substr(dept_name,2,length(dept_name))
as twosfrom dept c where c.fact_code='B01R' and c.flag='A'and c.dept_name like 'き%'
and d.fact_code=c.fact_code
and d.fact_area=c.fact_area
and d.dept_no=c.dept_no
and c.dept_name=d.dept_name
and dept_name is not null )
where d.fact_code='B01R' and d.flag='A' and d.dept_name like 'き%' and dept_name is not null */
批量更新数据
最新推荐文章于 2023-05-16 17:44:05 发布