oracle 11g with as问题

with c as (select 1 from dual)
select * from c
查询结果为空，为什么？

--相当于建了个e临时表
with e as (select '111' from dual)
select * from e;

你加一个单引号试试

怎么解决的？

已解决，还是谢谢楼上热心回答