3,491
社区成员
发帖
与我相关
我的任务
分享
procedure getRecordByUUID(tableName in varchar2, field in varchar2,fieldValue in varchar2,
startNum in integer,entNum in integer,records out SYS_REFCURSOR) is
p_sql varchar2(1000);
p_sql:='select * from (select t.*,rownum rn from '||tableName||' t '||'where '||field||' like '||chr(39)||'%'||fieldValue||'%'||chr(39)||' )where rn>= '||stratNum|| ' and rn <= '||entNum||';';
begin
open records for p_sql;
end;
end plan_searchTable;
procedure getRecordByUUID(tableName in varchar2, field in varchar2,fieldValue in varchar2,startNum in integer,entNum in integer,records out SYS_REFCURSOR)
as
begin
open records for
select *
from
(
select field,rownum row_num from tablename where field like '%'||fieldValue||'%';
)t
where row_num between startNum and entnum;
end;
/