Oracle case

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

Source: mastertraining.com.br

Similar codes

0 vote333 views1 answer
Json not contains mysql
SQL
0 vote398 views1 answer
Mariadb cast to int
SQL
2 votes344 views1 answer
Oracle convert run_duration to number
SQL
3 votes355 views2 answers
Sql get month name
SQL
0 vote325 views1 answer
Clone table structure mysql
SQL
0 vote359 views1 answer
Rollback to name in sql
SQL
0 vote380 views1 answer
Is not numeric sql
SQL
1 vote348 views1 answer
Oracle character set
SQL
0 vote380 views1 answer
Min mysql
SQL
0 vote362 views1 answer
Sql put two columns into one
SQL