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 ...