在访问中,我曾经在SQL查询中使用IIF函数
Select iif(X>=0,'Positive','Negative') from TableName;
在Oracle中有没有相同的东西?
用一个 CASE
CASE
select case when x >= 0 then 'Positive' else 'Negative' end as sign from tablename;