get_num_1.sql

来自「Oracle PLSQL for DBAs 源代码」· SQL 代码 · 共 14 行

CREATE OR REPLACE FUNCTION get_num (
   p_highval   NUMBER,
   p_lowval    NUMBER := 0,
   p_scale     PLS_INTEGER := 0
)
   RETURN NUMBER
IS
   l_ret   NUMBER;
BEGIN
   l_ret := ROUND (DBMS_RANDOM.VALUE (p_lowval, p_highval), p_scale);
   RETURN l_ret;
END;
/