Oracle动态游标

create or replace procedure extract_ldrk_to_zhk(partition_table_name in varchar2) is
--变量声明
TYPE dynamic_cur IS REF CURSOR;
cur dynamic_cur;--动态游标
select_sql varchar2(100);
XM T_WBXX_LDRK_TMP.XM%TYPE;
SF T_WBXX_LDRK_TMP.SF%TYPE;
--结束变量声明
begin
  select_sql := 'select xm, sf from '|| partition_table_name || ' where rownum < 10';
  open cur for select_sql;
  LOOP
    FETCH cur INTO XM, SF;

    EXIT WHEN cur%NOTFOUND;
  END LOOP;
  close cur;
end extract_ldrk_to_zhk;

实现的就是传分区表的某个分区名进去之后，可以访问该表的某两列。