-
select dbms_random.value from dual;
-
select dbms_random.value(1,100) from dual;
-
-
SELECT dbms_random.random FROM DUAL;
-
select dbms_random.normal from dual;
--------------------------------------------------------------------
select dbms_random.string('u',26) from dual;--upper case 最多60位
-
select dbms_random.string('l',26) from dual;--lower case
-
select dbms_random.string('a',26) from dual;--upper and lower
-
select dbms_random.string('x',26) from dual;--upper and number
-
select dbms_random.string('p',10) from dual;--all
-
-
--------------------------------------------------------------------
-
with t as
-
(select * from tab order by dbms_random.value)
-
select * from t where rownum<10;
产生一个0－100的随机数
select abs(mod(dbms_random.random,100)) from dual
