anybody can help me and show how to create cursor and use it in form builder

لايمكن عمل CREATE لل CURSOR وإنما ممكن إستخدام الCURSOR مباشرة في FORM BULIDER في أي ممكن نريد إستخدامه
وإليك مثال لإستخدام ال CURSOR

DECLARE
NO1 NUMBER;
STATE1 NUMBER;
CURSOR CUR_NO IS SELECT BOND_NO,BOND_STATE FROM BONDS ;
BEGIN
OPEN CUR_NO;
LOOP
FETCH CUR_NO INTO NO1,STATE1;
EXIT WHEN CUR_NO%NOTFOUND;
UPDATE BONDS_DESC SET BOND_STATE=STATE1
WHERE BOND_NO=NO1;
END LOOP;
CLOSE CUR_NO;
COMMIT;
END;

Or u Can do it like this


DECLARE
NO1 NUMBER;
STATE1 NUMBER;
CURSOR CUR_NO IS SELECT BOND_NO,BOND_STATE FROM BONDS ;
BEGIN
for rec_no in cur_no loop
UPDATE BONDS_DESC
SET BOND_STATE=rec_no.bond_state
WHERE BOND_NO=rec_no.bond_no;

END LOOP;
COMMIT;
END;

شكر للأخ fattah286 وللأخ mrashaideh على الشرح الرائع