WITH子句用法:
--相当于建了个e临时表
with e as (select * from user)
select * from e;
--相当于建了e、d临时表
with
e as (select * from user),
d as (select * from data)
select * from e, d where e.id = d.user;
Oracle 报错提示:ORA-32039:递归WITH子句必须具有列别名列表。
原因: 定义的临时表名与数据表名有重复
解决方案:重新定义临时表名