image.png
with
t as (
select 1 zfddbh,2 name from dual
union all
select 11 zfddbh,22 name from dual
)
select * from t;
image.png
with
t as (
select 1 zfddbh,2 name from dual
union all
select 11 zfddbh,22 name from dual
)
select * from t;
本文标题：oracle查询虚拟列，及获得多个列值
本文链接：https://www.haomeiwen.com/subject/intxmctx.html
网友评论