reference to wbsite:http://zhangzhongjie.iteye.com/blog/1948930#comments

DBMS_RANDON PACKAGE:

Define; It is procedure package that can generate randon number or character.

This package include initialize(),terminate(),values(),seed(),normal(),random(),string() and so on.But in generally use is value().

The following detail description above function.

1.dbms_randon.values() method.

Description:This function no parameter and return a 38 precision.note: 

 

 

DECLARE
BEGIN
  FOR i IN 1..10 LOOP
    dbms_output.put_line(dbms_random.value*100);
  END LOOP;
END;

95.864361159761670778062708247698987476
67.724652380863678121941241521641736201
45.723474120732253451242239595311117603
19.24915165031737209597467961083813978
62.390984553064153094580622535953624634
45.879161353436264498411158456524487241
76.197699077484826468014580442621559579
48.035290451818463727299430578495796567
62.449300430039071975269543614630741045
77.283357335232233325086000440826690281

 

posted on 2017-11-18 15:22  杨杨yang  阅读(131)  评论(0编辑  收藏  举报