Call dbms_random.normal to get a random number : DBMS_RANDOM « System Packages « Oracle PL / SQL






  1. Oracle PL / SQL
  2. System Packages
  3. DBMS_RANDOM

Call dbms_random.normal to get a random number

   
SQL>
SQL>
SQL> begin
  2        for i in 1 .. 10 loop
  3          dbms_output.put_line( dbms_random.normal );
  4        end loop;
  5      end;
  6      /
1.54614544732963133287654886045271895089
.4317388077546154281139738992526089097407
-.3932262942586239869251307222842090454052
-1.6670328488404622986050198363653775926
.6688556901515673452664296942201359807998
1.33788099021421741537616822012046180008
.4640589645668300518621566089428065420796
-.2593943569301190968371056213308217873704
-.928080380810723360417809948629051042821
.3610354349426925924563975682781230663073

PL/SQL procedure successfully completed.

SQL> --








Related examples in the same category

1.ROUND a DBMS_RANDOM.VALUE
2.This script illustrates the use of the DBMS_RANDOM package.
3.Use dbms_random.string to create random string
4.dbms_random.value
5.Random string with dbms_random.string
6.Seed a random value with dbms_random.seed
7.Round a random value from dbms_random.value
8.trunc a random value from dbms_random.value
9.mod(abs(dbms_random.random),50000)+1
10.Insert random numbers into a table
11.Insert random value to table