dbms_random是oracle提供的一個隨機函數包，以下介紹一些dbms_random的常用示例：
dbms_random.value用法：
生成一個大于等于0，小于等于1的38位小數
復制代碼 代碼如下:
-- FUNCTION value RETURN NUMBER;
select dbms_random.value from dual;
SQL> select dbms_random.value from dual;
VALUE
----------
0.61011338
復制代碼 代碼如下:
-- FUNCTION value RETURN NUMBER;
select dbms_random.value from dual;
SQL> select dbms_random.value from dual;
VALUE
----------
0.61011338
生成一個指定范圍內的數</ p>
復制代碼 代碼如下:
select dbms_random.value(100,0)
from dual;
SQL> select dbms_random.value(100,0)
2 from dual;
DBMS_RANDOM.VALUE(100,0)
------------------------
20.7742244285517
復制代碼 代碼如下:
-- FUNCTION value (low IN NUMBER, high IN NUMBER) RETURN NUMBER;
select dbms_random.value(100,0)
from dual;
SQL> select dbms_random.value(100,0)
2 from dual;
DBMS_RANDOM.VALUE(100,0)
------------------------
20.7742244285517
dbms_random.normal用法
獲取正態分布的隨機數
復制代碼 代碼如下:
select dbms_random.normal from dual;
SQL> select dbms_random.normal from dual;
NORMAL
----------
-1.7330759
復制代碼 代碼如下:
select dbms_random.normal from dual;
SQL> select dbms_random.normal from dual;
NORMAL
----------
-1.7330759
dbms_random.string用法
獲取指定字符串
復制代碼 代碼如下:
/* "opt" specifies that the returned string may contain:
'u','U' : upper case alpha characters only
'l','L' : lower case alpha characters only
'a','A' : alpha characters only (mixed case)
'x','X' : any alpha-numeric characters (upper)
'p','P' : any printable characters
*/
SQL>
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;
復制代碼 代碼如下:
--FUNCTION string (opt char, len NUMBER)
/* "opt" specifies that the returned string may contain:
'u','U' : upper case alpha characters only
'l','L' : lower case alpha characters only
'a','A' : alpha characters only (mixed case)
'x','X' : any alpha-numeric characters (upper)
'p','P' : any printable characters
*/
SQL>
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;
DBMS_RANDOM.STRING(‘U',10)
―――――――――-
TXREHAICRI
VDTMXZORVB
udavjpudfb
hvfqhjjdgz
tZoanQzxtX
siATLEZXQa
2LWWZ3H3L5
ZF6MKKG1R7
#/j5IPva(W
sJe/srX:ZB
10 rows selected
dbms_random.seed用法
主站蜘蛛池模板：
晋中市|
赤城县|
江华|
聂荣县|
同心县|
分宜县|
临安市|
信宜市|
伽师县|
当涂县|
合水县|
北宁市|
长子县|
赣榆县|
桐城市|
基隆市|
济阳县|
三原县|
罗江县|
巴林左旗|
越西县|
萍乡市|
巴东县|
浮山县|
长葛市|
广河县|
台中县|
陕西省|
施秉县|
三门县|
海城市|
扶余县|
泾阳县|
沂源县|
临洮县|
南开区|
临洮县|
开远市|
前郭尔|
黔西县|
波密县|
