批量更新数据

 update dept d set d.dept_name=(select 'B2 '||substr(dept_name,2,length(dept_name))
as twosfrom 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 */