17,140
社区成员




with t0 as (select '北京' as a from dual),
t1 as(select '北京' as a, 1 as b from dual union select '北京' as a, 2 as b from dual),
t2 as (select '北京' as a, 3 as c from dual union select '北京' as a, 4 as c from dual union select '北京' as a, 5 as d from dual),
t3 as (select '北京' as a, 6 as d from dual)
select t0.a, b, c, d from
(
select nvl(t0.a, t2.a) a, nvl(t0.rn, t2.rn) rn, b, c from
(
select nvl(t0.a, t1.a) a, nvl(t0.rn, t1.rn) rn, b from
(select a, rownum rn from t0) t0
full join (select a, b, rownum rn from t1) t1 on (t0.a = t1.a and t0.rn = t1.rn)
) t0
full join (select a, c, rownum rn from t2) t2 on (t0.a = t2.a and t0.rn = t2.rn)
) t0
full join (select a, d, rownum rn from t3) t3 on (t0.a = t3.a and t0.rn = t3.rn)
;