Oracle Random Integers: Generate with DBMS_RANDOM

An example of generating random integers using the DBMS_RANDOM package in Oracle database.

SELECT FLOOR(DBMS_RANDOM.VALUE(1, 100)) AS random_integer
FROM DUAL;

The above example will generate a random integer between 1 and 100. You can adjust the range as needed to generate random integers in different ranges.

bannerAds