Skip to main content

secure_rand

1. SECURE_RAND Function​

The SECURE_RAND function in H2 database is used to generate a random binary string of a specified length.

2. Syntax​

The syntax for the SECURE_RAND function in H2 database is as follows:

SECURE_RAND(length)

Arguments​

  • length: The length of the random binary string to be generated. It should be a positive integer value.

Return​

  • The SECURE_RAND function returns a binary string of the specified length.

3. Notes​

  • The SECURE_RAND function in H2 database uses a cryptographically secure random number generator to generate the random binary string.
  • The length argument determines the number of bytes in the output string, not the number of characters.
  • The generated random binary string is encoded using hexadecimal characters.

4. Examples​

Here are a few examples demonstrating the usage of the SECURE_RAND function in H2 database:

Example 1 - Generating a random binary string of length 10:​

SELECT SECURE_RAND(10) AS random_string;

Output:

random_string
---------------------
19BB8E8F9A6CC3D9C3

Example 2 - Generating random binary strings of different lengths:​

SELECT SECURE_RAND(5) AS random_string_1, SECURE_RAND(8) AS random_string_2;

Output:

random_string_1 | random_string_2
----------------+----------------
C8FEDCBA98      | 78FEE5DCBA9876

There are no directly related functions to the SECURE_RAND function in H2 database. However, you can use other string manipulation functions to further process the generated random string if needed.