RANDOMNUMBER v17

The RANDOMNUMBER() function returns a random number between 0 and 268,435,455. The signature is:

RANDOMNUMBER() RETURNS NUMBER

Examples

This example uses the RANDOMNUMBER function to return a cryptographically strong random number:

DECLARE
  result NUMBER;
BEGIN
  result := DBMS_CRYPTO.RANDOMNUMBER();
  DBMS_OUTPUT.PUT_LINE(result);
END;