oracle游标:fetch和for循环游标

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;