--page在上面必须已经声明declare delRows number:=0; begin if page>1 then delRows:=(page-1)*rows; end if; end;
set serveroutput on; declare page number := 4; rows number := 3; delRows number:=0; begin if page>1 then delRows:=(page-1)*rows; end if; dbms_output.put_line(delrows); end;
CREATE OR REPLACE FUNCTION GETDELPAGES(PAGE IN NUMBER, ROW_PAGE IN NUMBER) RETURN NUMBER IS DELPAGE NUMBER(6); BEGIN IF PAGE > 1 THEN DELPAGE =(PAGE - 1) * ROW_PAGE; ELSE DELPGAE = 0; END IF; RETURN DELPAGE; END;
delRows number:=0;
begin
if page>1 then
delRows:=(page-1)*rows;
end if;
end;
declare
page number := 4;
rows number := 3;
delRows number:=0;
begin
if page>1 then
delRows:=(page-1)*rows;
end if;
dbms_output.put_line(delrows);
end;
CREATE OR REPLACE FUNCTION GETDELPAGES(PAGE IN NUMBER, ROW_PAGE IN NUMBER)
RETURN NUMBER IS
DELPAGE NUMBER(6);
BEGIN
IF PAGE > 1 THEN
DELPAGE =(PAGE - 1) * ROW_PAGE;
ELSE
DELPGAE = 0;
END IF;
RETURN DELPAGE;
END;