1SELECT
2DECODE (t.column_name, 1, 'Southlake',
3 2, 'San Francisco',
4 3, 'New Jersey',
5 4, 'Seattle',
6 'Non domestic') new_name
7FROM table_name t
8 # If warehouse_id is not 1, 2, 3, or 4, then the function returns 'Non domestic'.