oracle 基本用法

with as的用法

　　with as 是在内存中会间理一个临时表，基本使用：

with temp_table as 
     (select * from table)
 
select * from temp_table

　　如果需要建立多个临时表，则使用：

with temp_tablea as
     (select * from tablea),
       temp_tableb as 
     (select * from tableb)

 

转载于:https://www.cnblogs.com/CanDmy/p/11244035.html