oracle中取模取整方法
declare
i integer;
begin
SELECT TRUNC(1+299*dbms_random.value) into i FROM dual;
i := i mod 5;--取模
i := trunc(0/ 300);--取整
dbms_output.put_line(i);
end;
i integer;
begin
SELECT TRUNC(1+299*dbms_random.value) into i FROM dual;
i := i mod 5;--取模
i := trunc(0/ 300);--取整
dbms_output.put_line(i);
end;
lunzi
2008-01-31 23:51:07
评论:0
阅读:604
引用:0