The following query
SELECT DECODE(country_id, 1, 'United States', 2, 'England') FROM customers;
returns:
- 'United States' if the country_id is 1
- 'England' if country_id is 2
- NULL if country_id isn't in the range 1 to 2
The following query
SELECT DECODE(country_id, 1, 'United States', 2, 'England') FROM customers;
returns: