很弱的一个,仅供参考create or replace function query4page(v_start int,v_end int,v_sql varchar2) return sys_refcursor is return_cursor sys_refcursor; begin dbms_output.put_line('[SQL:] select b_.* from (select a_.*, rownum rn_ from ('||v_sql||') a_ where rownum<='||v_end||' b_ where b_.rn_>='||v_start); open return_cursor for 'select b_.* from (select a_.*, rownum rn_ from ('||v_sql||') a_ where rownum<='||v_end||' b_ where b_.rn_>='||v_start; return return_cursor; end; / http://bbs.inthirties.com/thread-155-1-1.html
return sys_refcursor
is
return_cursor sys_refcursor;
begin
dbms_output.put_line('[SQL:] select b_.* from (select a_.*, rownum rn_ from ('||v_sql||') a_ where rownum<='||v_end||' b_ where b_.rn_>='||v_start);
open return_cursor for 'select b_.* from (select a_.*, rownum rn_ from ('||v_sql||') a_ where rownum<='||v_end||' b_ where b_.rn_>='||v_start;
return return_cursor;
end;
/
http://bbs.inthirties.com/thread-155-1-1.html