--使用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;
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;