oracle中批量修改

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