oracle case and decode function syntax

Oracle doesn't provide such IIF Function. Instead, try using one of the following alternatives: DECODE Funciton: SELECT DECODE(EMP_ID, 1, 'True', 'False') from Employee CASE Function: SELECT CASE WHEN EMP_ID = 1 THEN 'True' ELSE 'False' END from Employee