Declare
Cursor CursorC Is Select * From t;
CursorCR CursorC %Rowtype;
Begin
For CursorCR In CursorC Loop
Update t Set t.a=CursorCR .b Where a_ID=CursorCR .a_ID;
End Loop;
End;
Cursor CursorC Is Select * From t;
CursorCR CursorC %Rowtype;
Begin
For CursorCR In CursorC Loop
Update t Set t.a=CursorCR .b Where a_ID=CursorCR .a_ID;
End Loop;
End;
http://lujian811.blog.163.com/blog/static/10190113201042483517630/