|
建立一个游标 用动态语句拼接出来
create or replace procedure pr_test(p_ref out sys_refcursor)
is
v_rq1 varchar2(8000);
begin
execute immediate 'select wm_concat(to_char(rq,'''||'yyyy-mm-dd'||''')) from
(select trunc(sysdate)+rownum-1 rq from dual connect by rownum<4) t ' into v_rq1;
v_rq1:=replace(v_rq1,',',''',''');
v_rq1:=''''||v_rq1||'''';
v_rq1:='select '||v_rq1|| 'from dual';
open p_ref for v_rq1;
end;
|
|