PL/SQL产生随机数

--产成随机数

--带小数
--SELECT DBMS_RANDOM.VALUE(10000000000000000000,99999999999999999999) FROM DUAL;

--不带小数
--SELECT CAST(DBMS_RANDOM.VALUE(100,999) AS INT) FROM DUAL;


SELECT TO_CHAR(DBMS_RANDOM.VALUE(10000000000000000000,99999999999999999999)) FROM DUAL;