SELECT DBMS_RANDOM.RANDOM FROM DUAL;
select substr(cast(dbms_random.value as varchar2(38)),3,4) from dual --生成 4 位随机数
select * from (select * from mobile_num order by dbms_random.random) where rownum < 2 随机取一条数据
select substr(cast(dbms_random.value as varchar2(38)),3,4) from dual --生成 4 位随机数
select * from (select * from mobile_num order by dbms_random.random) where rownum < 2 随机取一条数据