oracle case

1SELECT product_id, product_type_id,
2  CASE product_type_id
3    WHEN 1 THEN 'Book'
4    WHEN 2 THEN 'Video'
5    WHEN 3 THEN 'DVD'
6    WHEN 4 THEN 'CD'
7    ELSE 'Magazine'
8  END
9FROM products;