select '%' Pram1,'全部' Pram1_desc from dual union all
select '1' Pram1,'核心指标' Pram1_desc from dual union all
select '0' Pram1,'非核心指标' Pram1_desc from dual
此查询语句完成的功能是怎么样的呢?诚心求解!谢谢各位!
select '1' Pram1,'核心指标' Pram1_desc from dual union all
select '0' Pram1,'非核心指标' Pram1_desc from dual
此查询语句完成的功能是怎么样的呢?诚心求解!谢谢各位!
% 全部
1 核心指标
0 非核心指标
with tb1 as(
select '%' Pram1,'全部' Pram1_desc from dual union all
select '1' Pram1,'核心指标' Pram1_desc from dual union all
select '0' Pram1,'非核心指标' Pram1_desc from dual
)
select * from tb1;PRAM1 PRAM1_DESC
----- ----------
% 全部
1 核心指标
0 非核心指标