游标参与循环的三种情况:
(1)declare cursor-->open cursor-->loop--->fetch curosr into -->end loop-->close cursor
这种情况每次调用fetch后游标将移动到下一条记录,但是我们要自己构造循环
declare
v_name tdz.vxm%TYPE;--%TYPE可以直接用取出字段的类型
v_class tdz.vbj%TYPE;
v_classes tdz.vbj%TYPE;
cursor mycoursor IS
SELECT vxm.vbj FROM tdz WHERE vbj=v_classes;
BEGIN
v_classes:='tang';
---------------------------
open mycoursor;
------------------------
loop
fetch mycursor