Declare
Cursor MyCursor Is Select * From table;
myRow MyCursor%Rowtype;
Begin
For myRow In MyCursor Loop
Update pptj_drumbeating Set PJ_description=myRow.reamrk2 Where PJ_ID=myRow.PJ_ID;
End Loop;
End;
Declare
Cursor MyCursor Is Select * From table;
myRow MyCursor%Rowtype;
Begin
For myRow In MyCursor Loop
Update pptj_drumbeating Set PJ_description=myRow.reamrk2 Where PJ_ID=myRow.PJ_ID;
End Loop;
End;