我可以从使用形成的查询创建表吗with clause?
with
Sure:
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