1,fetch 显式的open,close
Declare
Cursor cur Is
Select xtwldm From xtm14;
curRow cur%Rowtype;
Begin
Open Cur;
Loop
Fetch cur
Into currow;
Exit When cur%Notfound;
dbms_output.put_line(currow.xtwldm);
End Loop;
Close cur;
End;
2,for
Declare
Cursor cur Is
Select xtwldm From xtm14;
Begin
For currow In cur Loop
dbms_output.put_line(currow.xtwldm);
End Loop;
End;
本文内容由网友自发贡献,版权归原作者所有,本站不承担相应法律责任。如您发现有涉嫌抄袭侵权的内容,请联系:hwhale#tublm.com(使用前将#替换为@)