Shulou(Shulou.com)06/03 Report--

Number of pages returned by CREATE OR REPLACE Function get

(

Line number _ In number

Rows per page _ In number

) Return Varchar2

Is

V _ serial number number

I number

Begin

Select ceil (line number _ In/ rows per page _ In) into i from dual

Select 0 into v _ serial number from dual

While v _ serial number = 0 and line number _ In is not null loop

Select page number into v _ serial number from (

Select case when line number _ In ((iMur1) * rows per page _ In) then i else 0 end as page number from dual)

I:=i+1

End loop

Return v _ serial number

Number of pages returned by End get

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.