如果數(shù)據(jù)類型相似,可以使用as配合union來結(jié)合,例如
select c1 as a,c2 as b,null as c from t1 union
select cc1 as a,cc2 as b,cc3 as c from t2;
其中,使用null來確保連個(gè)select有相同的列數(shù).
前提是兩個(gè)select選擇的同一列的數(shù)據(jù)類型相似.

with t1 as (select 1 from dual),

    t2 as (select 2 from dual)

select * from t1, t2