Oracle dbms_random.value, dbms_random.value

Oracle dbms_random.value, dbms_random.value

Dbms_random is a package that can generate random values or strings. There are two usage methods for value () in the package:
If there is no parameter in the first type, a 38-bit precision value is returned, ranging from 0.0 to 1.0, excluding 1.0:
The second value has two parameters: the first parameter indicates the lower limit and the second parameter indicates the upper limit. A number between the lower limit and the upper limit is generated, excluding the upper limit:
Example 1: No parameter usage, and 10 random numbers between 1 and 99 are output.

<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: Use parameters and output any 10 numbers between 1 and 100

<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>