--产成随机数
--带小数
--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;