oracle分页如何查total,oracle分页查询

createorreplaceprocedureget_sys_log(

iv_begindateinsystem_log.operate_datetime%type,

iv_enddateinsystem_log.operate_datetime%type,

iv_usernameinsystem_log.user_id%type,

iv_modelinsystem_log.operate_model%type,

iv_pageIndexinnumber,

iv_pageTotalinnumber,

ov_totalnum outnumber,

ov_cur        out system_manage.refcursor)isbeginselectcount(rownum)intoov_totalnumfromsystem_log    a,system_userbwherea.user_id=b.user_idanda.operate_datetime>=iv_begindateanda.operate_datetime<=iv_enddate+1andb.user_namelike'%'||nvl(iv_username, b.user_name)||'%'anda.operate_modellike'%'||nvl(iv_model, a.operate_model)||'%';openov_curforselect*from(selectc.*,

rownum tempnumfrom(selectb.user_nameuser_name,

b.user_iduser_id,

a.operate_datetime operate_datetime,

a.operate_model operate_model,

a.operate_event operate_event,

a.old_content old_content,

a.new_content new_contentfromsystem_log    a,system_userbwherea.user_id=b.user_idanda.operate_datetime>=iv_begindateanda.operate_datetime<=iv_enddate+1andb.user_namelike'%'||nvl(iv_username, b.user_name)||'%'anda.operate_modellike'%'||nvl(iv_model, a.operate_model)||'%'orderbya.operate_datetimedesc, b.user_name, a.operate_model

) cwhererownum<=(iv_pageIndex)*iv_pageTotal)wheretempnum>(iv_pageIndex-1)*iv_pageTotal;end;