PLSQL - Cursor Liked For Loop Example

    BEGIN
        FOR RESULT IN (
            SELECT C.CASEKEY AS THECASEKEY, CE.CASEEVENTKEY AS THECASEEVENTKEY
            FROM CASES C
            JOIN CASEEVENT CE ON C.CASEKEY = CE.CASEKEY
            )
        LOOP
            UPDATE CASES
            SET CURRENTCASEEVENTKEY = RESULT.THECASEEVENTKEY
            WHERE CASEKEY = RESULT.THECASEKEY;
        END LOOP;
    END;