v_value_nr:= dbms_random.value[(min, max)]; : DBMS_RANDOM « PL SQL Programming « Oracle PL/SQL Tutorial

1. Oracle PL/SQL Tutorial
2. PL SQL Programming
3. DBMS_RANDOM

SQL>
SQL> --Generates a random value between the MINand MAX numbers passed as parameters (between 0 and 1 if parameters are omitted) with 38 digits after the decimal point.
SQL>
SQL> declare
  2      v1_nr number:=dbms_random.value(10,15);
  3  begin
  4      DBMS_OUTPUT.put_line('Float:'||v1_nr);
  5  end;
  6  /
Float:13.1192638925165964762502277715685751274

PL/SQL procedure successfully completed.

SQL>