RANDOMNUMBER

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

RANDOMNUMBER() RETURNS NUMBER

Examples

The following 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;