BEGIN
dbms_random.seed(0);
END; Statement processed.
SELECT ROW_NUMBER() OVER (ORDER BY first_roll) rn,
first_roll,
reroll,
CASE WHEN first_roll < 4 THEN reroll ELSE first_roll END final
FROM (
SELECT FLOOR(DBMS_RANDOM.VALUE * 6) + 1 first_roll, FLOOR(DBMS_RANDOM.VALUE * 6) + 1 reroll
FROM DUAL
CONNECT BY LEVEL <= 8
)
ORDER BY rn| RN | FIRST_ROLL | REROLL | FINAL | 1 | 1 | 5 | 5 | 2 | 2 | 2 | 2 | 3 | 3 | 1 | 1 | 4 | 3 | 6 | 6 | 5 | 3 | 5 | 5 | 6 | 3 | 2 | 2 | 7 | 5 | 3 | 3 | 8 | 6 | 5 | 5 |
|---|