DBMS_Random 随机数

select dbms_random.value from dual;  --产生一个0-1的随机数
select dbms_random.value(100,0) from dual;--产生一个0-100之间的小数
select dbms_random.normal from dual;--正态分布随机数

select dbms_random.string('u',10) from dual  --大写字母
union all
select dbms_random.string('U',10) from dual
union all
select dbms_random.string('l',10) from dual  --小写字母
union all
select dbms_random.string('L',10) from dual
union all
select dbms_random.string('a',10) from dual  -- 大小写混合字母
union all
select dbms_random.string('A',10) from dual
union all
select dbms_random.string('x',10) from dual  --大写 字母数字混合
union all
select dbms_random.string('X',10) from dual
union all
select dbms_random.string('p',10) from dual  --特殊字符混合
union all
select dbms_random.string('P',10) from dual;

select dbms_random.value from dual connect by level<10