如果是9i稍微改改就可以
select memberid as "会员号",membername as "姓名",
case area
when 0 then 'A区'
when 1 then 'B区'
end as "区域",
case gender
when 0 then '男'
when 1 then '女'
end as "性别",registerdate "注册日期"
from memberinfo8i及以下版本用decode实现,9i也适用
select memberid as "会员号",membername as "姓名",
decode(area,0,'A区',1,'B区') as "区域",
decode(gender,0,'男',1,'女') as "区域",
registerdate "注册日期"
from memberinfo
select memberid as "会员号",membername as "姓名",
case area
when 0 then 'A区'
when 1 then 'B区'
end as "区域",
case gender
when 0 then '男'
when 1 then '女'
end as "性别",registerdate "注册日期"
from memberinfo8i及以下版本用decode实现,9i也适用
select memberid as "会员号",membername as "姓名",
decode(area,0,'A区',1,'B区') as "区域",
decode(gender,0,'男',1,'女') as "区域",
registerdate "注册日期"
from memberinfo
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货