[oracle] with子查詢

with指令類似建立一個臨時view提供查詢。


範例：

with DATA as (select * from tablename where a <= 1)
select * from DATA where a <= 0.5

(支援left join, inner join關聯查詢)