oracle random函数,Oracle随机函数之dbms_random使用详解(2)

SQL> SELECT USERENV('SESSIONID')

2 FROM DUAL;

USERENV('SESSIONID')

--------------------

15140521

SQL> BEGIN

2 dbms_random.seed(100);

3 END;

4 /

PL/SQL procedure successfully completed

SQL> SELECT DBMS_RANDOM.value

2 FROM DUAL

3 CONNECT BY LEVEL < 10;

VALUE

----------

0.53801770

0.67499536

0.65362270

0.76351985

0.29859834

0.40522032

0.99551636

0.39565580

0.18074760

9 rows selected

复制代码 代码如下:

SQL> SELECT USERENV('SESSIONID')

2 FROM DUAL;

USERENV('SESSIONID')

--------------------

15140521

SQL> BEGIN

2 dbms_random.seed(100);

3 END;

4 /

PL/SQL procedure successfully completed

SQL> SELECT DBMS_RANDOM.value

2 FROM DUAL

3 CONNECT BY LEVEL < 10;

VALUE

----------

0.53801770

0.67499536

0.65362270

0.76351985

0.29859834

0.40522032

0.99551636

0.39565580

0.18074760

9 rows selected

--SESSION 2

复制代码 代码如下:

SQL> SELECT USERENV('SESSIONID')

2 FROM DUAL;

USERENV('SESSIONID')

--------------------

15140517

SQL> BEGIN

2 dbms_random.seed(100);

3 END;

4 /

PL/SQL procedure successfully completed

SQL> SELECT DBMS_RANDOM.value

2 FROM DUAL

3 CONNECT BY LEVEL < 10;

VALUE

----------

0.53801770

0.67499536

0.65362270

0.76351985

0.29859834

0.40522032

0.99551636

0.39565580

0.18074760

9 rows selected

复制代码 代码如下:

SQL> SELECT USERENV('SESSIONID')

2 FROM DUAL;

USERENV('SESSIONID')

--------------------

15140517

SQL> BEGIN

2 dbms_random.seed(100);

3 END;

4 /

PL/SQL procedure successfully completed

SQL> SELECT DBMS_RANDOM.value

2 FROM DUAL

3 CONNECT BY LEVEL < 10;

VALUE

----------

0.53801770

0.67499536

0.65362270

0.76351985

0.29859834

0.40522032

0.99551636

0.39565580

0.18074760

9 rows selected

免责声明：本站所有文章和图片均来自用户分享和网络收集，文章和图片版权归原作者及原出处所有，仅供学习与参考，请勿用于商业用途，如果损害了您的权利，请联系网站客服处理。