WITH TAB AS (SELECT 1 AS A ,0 AS B FROM DUAL UNION ALL
SELECT 1 AS A ,1 AS B FROM DUAL UNION ALL
SELECT 2 AS A ,3 AS B FROM DUAL UNION ALL
SELECT 4 AS A ,4 AS B FROM DUAL)
SELECT a,b,CASE WHEN a=b then 'Yes' ELSE 'No' END AS result   FROM tab
/

Select a, b, decode(case
                    when a=b then '1'
                    when a<>b then '0'
                    end), '1', 'Yes', '0', 'No') Result

select a, b, deoode(a, b, 'Yes', 'No') result
from mytab
/