请问oracle里面有随机函数吗？怎么用？

Question

dbms_output.put_line(trunc(dbms_random.value(1,5)));

Answer 1

SQL> select dbms_random.value(0,1) from dual;DBMS_RANDOM.VALUE(0,1)
----------------------
            .149142615SQL> select dbms_random.value(0,1) from dual;DBMS_RANDOM.VALUE(0,1)
----------------------
            .642692202SQL> select dbms_random.value(0,1) from dual;DBMS_RANDOM.VALUE(0,1)
----------------------
            .657347051SQL> select dbms_random.value(0,1) from dual;DBMS_RANDOM.VALUE(0,1)
----------------------
            .100336579

Answer 2

SQL> desc dbms_random
PROCEDURE INITIALIZE
自变量名称                       类型                    输入/输出默认值？
------------------------------ ----------------------- ------ --------
 VAL                            BINARY_INTEGER          IN
FUNCTION NORMAL RETURNS NUMBER
FUNCTION RANDOM RETURNS BINARY_INTEGER
PROCEDURE SEED
自变量名称                       类型                    输入/输出默认值？
------------------------------ ----------------------- ------ --------
 VAL                            BINARY_INTEGER          IN
PROCEDURE SEED
自变量名称                       类型                    输入/输出默认值？
------------------------------ ----------------------- ------ --------
 VAL                            VARCHAR2                IN
FUNCTION STRING RETURNS VARCHAR2
自变量名称                       类型                    输入/输出默认值？
------------------------------ ----------------------- ------ --------
 OPT                            CHAR                    IN
 LEN                            NUMBER                  IN
PROCEDURE TERMINATE
FUNCTION VALUE RETURNS NUMBER
FUNCTION VALUE RETURNS NUMBER
自变量名称                       类型                    输入/输出默认值？
------------------------------ ----------------------- ------ --------
 LOW                            NUMBER                  IN
 HIGH                           NUMBER                  IN