Oracle Dbms_random.value

Dbms_random is a package that can generate random numbers or strings. There are two ways to use value () in a package
The first without parameter returns a numeric value with a 38-bit precision ranging from 0.0 to 1.0, excluding 1.0:
The second value has two parameters, the first is the lower limit, the second is the upper limit, and a number between the lower bound and the upper bound is generated, without the upper bound:
Example 1: No parameter usage, random 10 numbers between outputs 1 to 99

<span style= "FONT-SIZE:18PX;" >SQL> set serverout on sql> begin    2 for    i in 1..10 loop    3      dbms_output.put_line (round (dbms_ random.value*100));    4    end loop;    5  end;    6  /</span>

Example 2: Any 10 numbers from 1 to 100 with the use of parameters

<span style= "FONT-SIZE:18PX;" >SQL> begin    2 for    i in 1..10 loop    3      dbms_output.put_line (trunc (Dbms_random.value (1,101)) ;    4    end loop;    5  end;    6  /</span>

Oracle Dbms_random.value