oracle中如何用rownum實現分頁

今天有個技術群裡有人問到這個問題。

把一年多前做的sql語句拿出來獻醜了，拋磚引玉，有更好的方法歡迎交流。

$where="WHERE USERID='$userId'";
$orderBy ="ORDER BY ID desc";
$totalNum=$this->favoritesTotal($userId);
if($curPage <= 0 || $curPage > ceil($totalNum / $PerPageNum)){
    $curPage = 1;
}
$rowBegin=$PerPageNum*($curPage-1)+1;
$rowEnd = $curPage*$PerPageNum;
$sqlList="select * from (select rownum row_num,a.* from (select infoid,
infotype,to_char(INFOTIME,'yyyy-mm-dd') INFOTIME,infoname,id,tablename
from favorite $where $orderBy) a)where row_num between
$rowBegin and $rowEnd";