導(dǎo)讀:1建站知識(shí)dbms_random是oracle提供的一個(gè)隨機(jī)函數(shù)包,本文將詳細(xì)介紹函數(shù)的使用,需要的朋友可以參考下營(yíng)銷型網(wǎng)站建設(shè)seo網(wǎng)站關(guān)鍵詞優(yōu)化。

dbms_random是oracle提供的一個(gè)隨機(jī)函數(shù)包，以下介紹一些dbms_random的常用示例： dbms_random.value用法： 生成一個(gè)大于等于0，小于等于1的38位小數(shù)

復(fù)制代碼 代碼如下:

-- FUNCTION value RETURN NUMBER; select dbms_random.value from dual; SQL> select dbms_random.value from dual; VALUE ---------- 0.61011338

復(fù)制代碼 代碼如下:

-- FUNCTION value RETURN NUMBER; select dbms_random.value from dual; SQL> select dbms_random.value from dual; VALUE ---------- 0.61011338

生成一個(gè)指定范圍內(nèi)的數(shù)</ p>

復(fù)制代碼 代碼如下:

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

復(fù)制代碼 代碼如下:

-- 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用法 獲取正態(tài)分布的隨機(jī)數(shù)

復(fù)制代碼 代碼如下:

select dbms_random.normal from dual; SQL> select dbms_random.normal from dual; NORMAL ---------- -1.7330759

復(fù)制代碼 代碼如下:

select dbms_random.normal from dual; SQL> select dbms_random.normal from dual; NORMAL ---------- -1.7330759

dbms_random.string用法 獲取指定字符串

復(fù)制代碼 代碼如下:

企業(yè)網(wǎng)站建設(shè)/* "opt" specifies that the returned string may contain: 'u','U' : upper case alpha charact網(wǎng)站建設(shè)ers 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('Useo網(wǎng)站優(yō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;

復(fù)制代碼 代碼如下:

--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;

關(guān)鍵詞標(biāo)簽: 函數(shù) 詳解