oracle中批量修改
时间：2021-07-01 10:21:17
帮助过：28人阅读
FOR cur
IN (
select t.tagcode
as code,t.tagname
as names
from YJX_SER_PARAME p,yjx_tag t
where p.label_code
= t.tagcode
order by t.tagcode
) loop
update YJX_SER_PARAME
set label_name
=cur.names
where label_code
= cur.code;
END loop ;
END ;
-- ----------------------------
UPDATE student s
SET s.name = (
SELECT b.name FROM boy b WHERE s.id = b.id AND s.name != b.name
)
WHERE EXISTS (
SELECT 1 FROM boy b WHERE s.id = b.id AND s.name != b.name
);
oracle中批量修改
标签：mes upd pre oracl col date 批量修改 bsp span
