在PL/SQL中返回游标中已删除的行

DECLARE
  CURSOR cur_data IS
    SELECT * FROM your_table WHERE condition;

TYPE cur_data_rec IS RECORD (
  col1 data_type1,
  col2 data_type2,
  ...
);

TYPE cur_data_tab IS TABLE OF cur_data_rec;

cur_data_result cur_data_tab;

OPEN cur_data;
FETCH cur_data BULK COLLECT INTO cur_data_result;
CLOSE cur_data;

DECLARE
  CURSOR cur_deleted_data IS
    SELECT *
    FROM TABLE(cur_data_result)
    WHERE your_condition_to_check_deleted_rows;
BEGIN
  -- 遍历集合变量中的每一行数据
  FOR rec IN cur_deleted_data LOOP
    -- 处理已删除的行
    -- ...
  END LOOP;
END;