I want to update column entire record of BOOKDATE_TO from my below query USING ORACLE PLSQL using loop or procedure : Here is the code I want book date_to to be updated I want a proper plsql code using procedure or loop that updated entire records of column book date_to

    SELECT
        r.resource_id,
        r.type,
        r.resort_id,
        r.parent_id,
        r.code,
        r.name,
        r.path,
        r.cashflowmanager_id,
        c.bookdate_from,
        c.bookdate_to,
        c.usage_date_from,
        c.usage_date_to
    FROM
        resourcebasei18n   r
        JOIN cashflowrule       c ON ( r.cashflowmanager_id = c.cashflowmanager_id )
    WHERE
        name = '4-Persoons Ranchtent'
        AND ( c.usage_date_from BETWEEN '01-APR-20' AND '01-MAY-20'
              OR c.usage_date_to BETWEEN '01-APR-20' AND '01-MAY-20' );