CREATE TABLE tAS WITH some_data AS ( SELECT 1 as some_value FROM dual UNION ALL SELECT 2 FROM dual) SELECT * FROM some_data
