create or replace procedure dong_test(pageindex number)
as
pages number;
cursor rs is select * from(select rownum rn,e.*from ecom e order by eid)e2 where rn>=pageindex*10+1 and rn<=pageindex*10+10;
begin
select count(eid) into pages from ecom;
if pages mod 10 =0 then
pages:=pages/10;
else
pages:=pages/10 +1;
end if;
dbms_output.put_line('总页数:'||pages);
for v_ecom in rs loop-- 循环打印
dbms_output.put_line(v_ecom.eid||v_ecom.ename||v_ecom.salary);
end loop;
end;
/
exec dong_test(pageindex number)
as
pages number;
cursor rs is select * from(select rownum rn,e.*from ecom e order by eid)e2 where rn>=pageindex*10+1 and rn<=pageindex*10+10;
begin
select count(eid) into pages from ecom;
if pages mod 10 =0 then
pages:=pages/10;
else
pages:=pages/10 +1;
end if;
dbms_output.put_line('总页数:'||pages);
for v_ecom in rs loop-- 循环打印
dbms_output.put_line(v_ecom.eid||v_ecom.ename||v_ecom.salary);
end loop;
end;
/
exec dong_test(pageindex number)