oracle查询虚拟列，及获得多个列值
2019-10-11 本文已影响0人
屎倒淋头还嚼便
image.png
with
t as (
select 1 zfddbh,2 name from dual
union all
select 11 zfddbh,22 name from dual
)
select * from t;
with
t as (
select 1 zfddbh,2 name from dual
union all
select 11 zfddbh,22 name from dual
)
select * from t;
