dbms_random.string('P',10)
#\j5IPva(W
2LWWZ3H3L5
– 那么当你再次调用相同的seed之后，一次产生的随机数还是4、6、1
FROM DUAL
dbms_random.string('U',10)
select dbms_random.value from dual;
union all

'p','P' : any printable characters
select
'l','L' : lower case alpha characters only
SELECT USERENV('SESSIONID')
-- FUNCTION value RETURN NUMBER;
SQL>
select
from dual

复制代码 代码如下:

'x','X' : any alpha-numeric characters (upper)
from dual
dbms_random.string('X',10)
DBMS_RANDOM.VALUE(100,0)
select

from dual;
生成一个大于等于0，小于等于1的38位小数
union all

复制代码 代码如下:

from dual
----------
dbms_random.normal用法
END;
'u','U' : upper case alpha characters only
select
from dual
20.7742244285517
select
获取正态分布的随机数

复制代码 代码如下:

DBMS_RANDOM.VALUE(100,0)
select
----------
select dbms_random.normal from dual;
--FUNCTION string (opt char, len NUMBER)
from dual
– seed有两种，一种是数值型的，一种是字符型(最大长度2000)的
10 rows selected
from dual
dbms_random.string('L',10)
from dual;
0.61011338
union all
select dbms_random.value(100,0)
SELECT DBMS_RANDOM.value
dbms_random.seed用法
dbms_random.string('P',10)
select
dbms_random.seed(6);
dbms_random.string('L',10)
from dual
'x','X' : any alpha-numeric characters (upper)
'l','L' : lower case alpha characters only
select
from dual
union all
union all
udavjpudfb
from dual
from dual
-1.7330759
select
dbms_random.string('U',10)
/
dbms_random.string用法
dbms_random.seed(6);
from dual;

复制代码 代码如下:

select
from dual
ZF6MKKG1R7
dbms_random.string('x',10)
FROM DUAL;

复制代码 代码如下:

复制代码 代码如下:

NORMAL
SQL>
select
from dual
BEGIN
dbms_random.string('l',10)
*/

END;

-1.7330759
------------------------
select dbms_random.value(100,0)
select
2 from dual;
SQL> select dbms_random.normal from dual;
'a','A' : alpha characters only (mixed case)

–可以设置seed来确定随机数的起始点，对于相同的seed而言，随机数的任意一次变化都将是确定的。
'a','A' : alpha characters only (mixed case)
union all
----------
select

复制代码 代码如下:

dbms_random.string('a',10)

TXREHAICRI

dbms_random.string('u',10)

NORMAL
from dual
SQL> select dbms_random.value(100,0)
from dual

VALUE
union all
-- FUNCTION value (low IN NUMBER, high IN NUMBER) RETURN NUMBER;
sJe/srX:ZB
union all

复制代码 代码如下:

select
/

复制代码 代码如下:

复制代码 代码如下:

select
SQL> select dbms_random.value from dual;
DBMS_RANDOM.STRING(‘U',10)
union all
union all
hvfqhjjdgz
select dbms_random.normal from dual;
-- FUNCTION value RETURN NUMBER;
/* "opt" specifies that the returned string may contain:
dbms_random.string('l',10)
union all

union all
CONNECT BY LEVEL < 10;
'u','U' : upper case alpha characters only

dbms_random.string('P',10)
dbms_random.string('A',10)
select

0.61011338

2 from dual;
SQL> select dbms_random.value(100,0)

union all
dbms_random.string('a',10)
from dual
VALUE
VDTMXZORVB
生成一个指定范围内的数</ p>
SQL> select dbms_random.normal from dual;

------------------------
select
select
from dual
siATLEZXQa
20.7742244285517
– 就是说，如果在某一时刻调用了seed，之后第一次产生的随机数是4，第二次是6，第三次是1，
union all
SELECT USERENV('SESSIONID')
获取指定字符串

BEGIN
from dual

dbms_random是oracle提供的一个随机函数包，以下介绍一些dbms_random的常用示例：
----------
from dual
select dbms_random.value from dual;
union all
'p','P' : any printable characters
select
--SESSION 1
CONNECT BY LEVEL < 10;
FROM DUAL;
select
dbms_random.string('X',10)
union all
tZoanQzxtX
union all

复制代码 代码如下:

dbms_random.string('A',10)
SQL> select dbms_random.value from dual;
dbms_random.string('P',10)
dbms_random.string('x',10)

—————————-
dbms_random.string('u',10)

/* "opt" specifies that the returned string may contain:
*/
union all
FROM DUAL
dbms_random.value用法：
from dual;

SELECT DBMS_RANDOM.value