-1

In access I used to use IIF function in SQL queries

Select iif(X>=0,'Positive','Negative') from TableName;

Is there any equivalent for that in Oracle ?

Thomas Carlton
  • 5,344
  • 10
  • 63
  • 126
  • Does this answer your question? [ORACLE IIF Statement](https://stackoverflow.com/questions/14791684/oracle-iif-statement) – underscore_d Jul 08 '20 at 13:18

1 Answers1

6

Use a CASE

select case 
         when x >= 0 then 'Positive'
         else 'Negative'
       end as sign
from tablename;