dbms_randon package

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
上一篇:JavaWeb基础: 学习大纲


下一篇:python/Django(增、删、改、查)操作