--plsql 中使用case
select case when code > 1 then name1
else case when code = 0 then name2
else case when code < 0 then name3
end as tbl_name
from table_name
--plsql 中使用case
select case when code > 1 then name1
else case when code = 0 then name2
else case when code < 0 then name3
end as tbl_name
from table_name