关于oracle
摘要：
1、游标updateDECLARECURSOR cur_stu IS//准备数据SELECT t.screenname,f.xueyaun,f.nj from temp14 f left join user_ t on t.screenname=f.userid for update ;//定义参数v_userid temp14.userid%TYPE;v_xueyuan temp14.xueyaun%TYPE;v_nj temp14.nj%TYPE;/打开游标BEGINOPEN cur_stu;LOOPFETCH cur_stu INTO v_userid,v_xueyuan,v_nj;EX 阅读全文
posted @ 2011-09-28 14:19 恓恓 阅读(85) 评论(1) 推荐(0)
浙公网安备 33010602011771号