oracle with as 的用法 with event_trace as (select * from w_user where user_name like '%a%') select * from event_trace 相当于建个临时表 也相当于是一个针对sql的别名 语法就是 with tempname as (select ....) select ...