select case com_type
when '1' then '合同'
when '2' then '订单'
else '合约' end as '合同类型' ,
decode(com_type,'1','合同' ,'2','订单') as '合同类型' from table
oracle。case when和decode用法
最新推荐文章于 2023-03-27 16:24:18 发布
select case com_type
when '1' then '合同'
when '2' then '订单'
else '合约' end as '合同类型' ,
decode(com_type,'1','合同' ,'2','订单') as '合同类型' from table