oracle数据分页通用写法
select <%=Fields%> from <%=TableName%> where <%=PrimaryKey%> in
( select <%=PrimaryKey%> from
(
select rownum rn,<%=PrimaryKey%> from
(select <%=PrimaryKey%> from <%=TableName%> <%=Filter%> <%=OrderBy%>)
)
where rn >= <%=StartNumber%> and rn <=<%=EndNumber%>
) <%=OrderBy%>";
总结的比较到位,写的很好,值得包装。2007-07-19 刘军