Question

oracle with as 缺失 SELECT 关键字，该怎么解决

Answer 1

with as语法 –针对一个别名 with tmp as (select * from tb_name) –针对多个别名 with tmp as (select * from tb_name), tmp2 as (select * from tb_name2), tmp3 as (select * from tb_name3), 其实就是把一大堆重复用到的sql语句放在with as里

Answer 2

在mysql里是系统默认追加了只返回一行的虚拟表机制，
而在oracle里的实现是制定一个默认的显示虚拟表：
select
''
as
id
from
dual;