About Oracle paged inquired sql,to everybody share share......

eg:

select * from (select a.*,rownum rn from (select * from prod) a where rownum <=(currentpage*5)) where rn >(currentpage-1)*5;

 

thx~