select t.*,case when t.is_valid=1 then t.chr_code || ' ' || t.chr_name || ' 已启用'
when t.is_valid = 2 then 'hahhahhahahha'
ELSE t.chr_code || ' ' || t.chr_name end as sys_name from tablename t
select t.*,case when t.is_valid=1 then t.chr_code || ' ' || t.chr_name || ' 已启用'
when t.is_valid = 2 then 'hahhahhahahha'
ELSE t.chr_code || ' ' || t.chr_name end as sys_name from tablename t