By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
CREATE TABLE t
AS
WITH some_data AS (
SELECT 1 as some_value
FROM dual
UNION ALL
SELECT 2
FROM dual
)
SELECT *
FROM some_data
2 rows affected
select *
from t
| SOME_VALUE |
|---|
| 1 |
| 2 |