DBMS_RANDOM.Value (random value) [ desc dbms_random]

DBMS_RANDOM.Value (random value)》

隨機產生1~100的浮點數

select dbms_random.value(1,100) from dual

隨機產生1~100的整數及100筆資料

create table test_random as

select round(dbms_random.value(1,100)) f1 from dual

connect by level<=100

01	-----------------------------------------------------------------------

02	SQL> desc dbms_random

03	PROCEDURE INITIALIZE

04	參數名稱                       類型                    In/Out 預設值？

05	------------------------------ ----------------------- ------ --------

06	VAL                            BINARY_INTEGER          IN

07	FUNCTION NORMAL RETURNS NUMBER

08	FUNCTION RANDOM RETURNS BINARY_INTEGER

09	PROCEDURE SEED

10	參數名稱                       類型                    In/Out 預設值？

11	------------------------------ ----------------------- ------ --------

12	VAL                            BINARY_INTEGER          IN

13	PROCEDURE SEED

14	參數名稱                       類型                    In/Out 預設值？

15	------------------------------ ----------------------- ------ --------

16	VAL                            VARCHAR2                IN

17	FUNCTION STRING RETURNS VARCHAR2

18	參數名稱                       類型                    In/Out 預設值？

19	------------------------------ ----------------------- ------ --------

20	OPT                            CHAR                    IN

21	LEN                            NUMBER                  IN

22	PROCEDURE TERMINATE

23	FUNCTION VALUE RETURNS NUMBER

24	FUNCTION VALUE RETURNS NUMBER

25	參數名稱                       類型                    In/Out 預設值？

26	------------------------------ ----------------------- ------ --------

27	LOW                            NUMBER                  IN

28	HIGH                           NUMBER                  IN

29	SQL> desc dbms_random

30	PROCEDURE INITIALIZE

31	參數名稱                       類型                    In/Out 預設值？

32	------------------------------ ----------------------- ------ --------

33	VAL                            BINARY_INTEGER          IN

34	FUNCTION NORMAL RETURNS NUMBER

35	FUNCTION RANDOM RETURNS BINARY_INTEGER

36	PROCEDURE SEED

37	參數名稱                       類型                    In/Out 預設值？

38	------------------------------ ----------------------- ------ --------

39	VAL                            BINARY_INTEGER          IN

40	PROCEDURE SEED

41	參數名稱                       類型                    In/Out 預設值？

42	------------------------------ ----------------------- ------ --------

43	VAL                            VARCHAR2                IN

44	FUNCTION STRING RETURNS VARCHAR2

45	參數名稱                       類型                    In/Out 預設值？

46	------------------------------ ----------------------- ------ --------

47	OPT                            CHAR                    IN

48	LEN                            NUMBER                  IN

49	PROCEDURE TERMINATE

50	FUNCTION VALUE RETURNS NUMBER

51	FUNCTION VALUE RETURNS NUMBER

52	參數名稱                       類型                    In/Out 預設值？

53	------------------------------ ----------------------- ------ --------

54	LOW                            NUMBER                  IN

55	HIGH                           NUMBER                  IN