DBMS_RANDOM : DBMS_RANDOM « PL SQL Programming « Oracle PL/SQL Tutorial






  1. Oracle PL/SQL Tutorial
  2. PL SQL Programming
  3. DBMS_RANDOM
SQL>
SQL> v_random_nr:= dbms_random.random;
SQL>
SQL> Returns a random integer value in the range of ?^31 to 2^31.
SQL>
SQL> declare
  2      v2_nr binary_integer:=dbms_random.random;
  3  begin
  4      DBMS_OUTPUT.put_line('Int:'||v2_nr);
  5  end;
  6  /
Int:-1254017024

PL/SQL procedure successfully completed.

SQL>








24.23.DBMS_RANDOM
24.23.1.DBMS_RANDOM
24.23.2.v_value_nr:= dbms_random.value[(min, max)];