oracle with as 语法,
========
WITH
========
用于一个语句中某些中间结果放在临时表空间的SQL语句 如 WITH tempTableName AS ( SELECT t.* FROM sales t ) SELECT * FROM tempTableName WHERE XXXXXXXXXXX
tempTableName 表就是WITH生成的中间表
oracle with as 语法,
========
WITH
========
用于一个语句中某些中间结果放在临时表空间的SQL语句 如 WITH tempTableName AS ( SELECT t.* FROM sales t ) SELECT * FROM tempTableName WHERE XXXXXXXXXXX
tempTableName 表就是WITH生成的中间表