????6. TERMINATE
???????????DBMS_RANDOM??????ú?????????????ú?????11gR1?м????????????
????????
????DBMS_RANDOM.TERMINATE;
??????????
????SQL> exec DBMS_RANDOM.TERMINATE;
????PL/SQL procedure successfully completed.
????7. VALUE
????????
????DBMS_RANDOM.VALUE
????RETURN NUMBER;
????DBMS_RANDOM.VALUE(
????low IN NUMBER??
????high IN NUMBER)
????RETURN NUMBER;
?????????????÷????????????Χ?????????0??С??1??????38λ?????С????
?????????????÷????????С???????????????Χ?????????low??С??high??
??????????
????SQL> select dbms_random.value from dual;
????VALUE
????----------
????.291782963
????SQL> select dbms_random.value(10??20) from dual;
????DBMS_RANDOM.VALUE(10??20)
????------------------------
????12.4079412
???????
????????VALUE????????38λ?????С????????????·???????
SQL> select dbms_random.value from dual;
VALUE
----------
.511020102
SQL> col value for 999999.9999999999999999999999999999999999999999999999999
SQL> select dbms_random.value from dual;
VALUE
---------------------------------------------------------
.1590863051775181450023750363985770254400000000000
SQL> /
VALUE
---------------------------------------------------------
.5831363280913832608492096535119024112700000000000
????????value?е????????999999.9999999999999999999999999999999999999999999999999????????????С??λ??????38λ???????????У??49λ?????dbms_random.value???????????????????????????????????49λ??????11λ????0?????仰?????Ч??????38λ??