【oracle游标使用】

1、使用游标替换两条记录值

declare
    cursor data_cursor is
        select step_property_id, step_no, step_kind_no
        from hs_fob.fob_bizstep
        where step_property_id = ('8042180001');
    step_no_temp      hs_fob.fob_bizstep.step_no%TYPE;
    step_kind_no_temp hs_fob.fob_bizstep.step_kind_no%TYPE;

begin
    for data_rec in data_cursor
        loop
            if data_rec.step_property_id = '8042180001' then

                select step_no, step_kind_no
                into step_no_temp, step_kind_no_temp
                from hs_fob.fob_bizstep
                where step_property_id = '8042180002';

                if data_rec.step_no > step_no_temp then

                    update hs_fob.fob_bizstep
                    set step_no      = step_no_temp,
                        step_kind_no = step_kind_no_temp
                    where step_property_id = '8042180001';

                    update hs_fob.fob_bizstep
                    set step_no      = data_rec.step_no,
                        step_kind_no = data_rec.step_kind_no
                    where step_property_id = '8042180002';

                end if;
            end if;
        end loop;
    commit;
end;
/