DECLARE
CURSOR cursor_changename IS
SELECT fprocinstid, frealusername
FROM cwt_wf_casedata
where frealusername is not null
ORDER BY fprocinstid;
TProcinstid NUMBER(10);
TRealusername VARCHAR2(400);
BEGIN
OPEN cursor_changename;
LOOP
FETCH cursor_changename
INTO TProcinstid, TRealusername;
EXIT WHEN cursor_changename%NOTFOUND;
UPDATE T_CASEPUBLISH
SET APPLYUSERNAME = TRealusername
WHERE PROCINSID = TProcinstid;
END LOOP; CLOSE cursor_changename;END;
CURSOR cursor_changename IS
SELECT fprocinstid, frealusername
FROM cwt_wf_casedata
where frealusername is not null
ORDER BY fprocinstid;
TProcinstid NUMBER(10);
TRealusername VARCHAR2(400);
BEGIN
OPEN cursor_changename;
LOOP
FETCH cursor_changename
INTO TProcinstid, TRealusername;
EXIT WHEN cursor_changename%NOTFOUND;
UPDATE T_CASEPUBLISH
SET APPLYUSERNAME = TRealusername
WHERE PROCINSID = TProcinstid;
END LOOP; CLOSE cursor_changename;END;
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货