oracle with使用

来源:互联网 发布:淘宝首页导航怎么去掉 编辑:程序博客网 时间:2024/06/07 02:10
--使用with临时表
with
q1 as (select 1+1.5 as P from dual),
q2 as (select 3*5 as Q from dual),
q3 as (select P,Q,P*Q from q1,q2)
select * from q3;
0 0