Oracle Decode

Oracle DECODE function compares expression to each search value one by one.
If expression is equal to a search, then return the result.
If no match is found, then returns default or null.

Oracle Decode example

SELECT name,
decode(id,  
1,  'Oracle9i', 
2,  'Oracle10G', 
3,  'Oracle11G' 
)
FROM tutorials;