SET SERVEROUTPUT ON

DECLARE
    CURSOR c_entertainer_id IS
    SELECT entertainer_id
    FROM ATA_ENTERTAINER
    FOR UPDATE;

    v_entertainer_id     ata_entertainer.entertainer_id%TYPE;

    CURSOR c_style IS
    SELECT entertainer_id, style_code
    FROM ATA_ENTERTAINERS_STYLE
    WHERE entertainer_id = v_entertainer_id
    FOR UPDATE;

    v_style_count   NUMBER;

    BEGIN
    FOR r_entertainer_id IN c_entertainer_id LOOP
    v_entertainer_id:=r_entertainer_id.entertainer_id;
    v_style_count:=0;
    FOR r_style IN c_style LOOP
    v_style_count:=v_style_count+1;

    UPDATE ATA_ENTERTAINER
    SET MORE_THAN_ONE = v_style_count
    WHERE CURRENT OF c_style;

            END LOOP;
            END LOOP;
        COMMIT;
    END;
/