长安英文网站建设,创建一个企业网站流程的步骤,wordpress 遍历用户,室内设计师必备的设计软件这段时间实在是很忙#xff0c;结婚、赶项目进度、被迫出书、教学。每件事都是不能得罪的。。。。前几天帮教务处修正oracle数据库数据问题#xff0c;把代码贴出来防止以后找不到了 declareCURSORcurTTT isselectXN,XM,XQ,KCMC,XF,BJMC fromCJB;XN1 VARCHAR2(10);XM1 VARCHA…这段时间实在是很忙结婚、赶项目进度、被迫出书、教学。每件事都是不能得罪的。。。。前几天帮教务处修正oracle数据库数据问题把代码贴出来防止以后找不到了 declare CURSOR curTTT is select XN,XM,XQ,KCMC,XF,BJMC from CJB;XN1 VARCHAR2(10);XM1 VARCHAR2(20); XQ1 NUMBER(1); KCMC1 VARCHAR2(40); XF1 VARCHAR2(10); BJMC1 VARCHAR2(40);begin----------------------------------------- if curTTT%isopen false then open curTTT; end if; fetch curTTT into XN1,XM1,XQ1,KCMC1,XF1,BJMC1; -- Dbms_Output.put(1);while curTTT%found loop if XF10 then update CJB set XF(select * from (select nvl(XF,0) from CJB where BJMCBJMC1 and KCMCKCMC1 and XQXQ1 and XNXN1 and XF0 ) where ROWNUM1)where BJMCBJMC1 and KCMCKCMC1 and XQXQ1 and XNXN1 and XMXM1; end if;if curTTT%rowcount0 thenexit;end if;fetch curTTT into XN1,XM1,XQ1,KCMC1,XF1,BJMC1;end loop; commit; close curTTT;-------------------------------------------- end;转载于:https://www.cnblogs.com/coffeeliu/archive/2006/09/30/518879.html