By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
select dbms_random.value() as rnd union all
select dbms_random.value() as rnd
| RND |
|---|
| .79263673293668402832745133398730975957 |
| .71377343882776975895876411444816767274 |
WITH
test_a as ( select dbms_random.value() as rnd ),
test_b as ( select * from test_a )
select * from test_a
union all
select * from test_b
| RND |
|---|
| .21692968397094372775858765087511007339 |
| .23820817422791858668852994820400455145 |