create or replace
FUNCTION "MIN_TWO" (paramone IN NUMBER,paramtwo IN NUMBER) RETURN NUMBER
IS
min_param NUMBER(18,2);
BEGIN
IF paramone>0 AND paramtwo>0 THEN
IF paramone>=paramtwo THEN
min_param:=paramtwo;
ELSE
min_param:=paramone;
END IF;
ELSE
min_param:=0;
END IF;
RETURN min_param;
END MIN_TWO;
oracle数据库2个数的最小值的函数
最新推荐文章于 2024-08-07 17:03:42 发布