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 vote123 views3 answers
Characters found after end of sql statement
SQL
0 vote131 views2 answers
Dumping sql table
SQL
0 vote115 views1 answer
Sql character index
SQL
0 vote118 views1 answer
Snap craft
SQL
11 votes111 views1 answer
How to get ddl for materialized view
SQL
22 votes126 views3 answers
Remove all records from table mysql
SQL
0 vote123 views1 answer
Mysql insert into select transaction c#
SQL
1 vote115 views1 answer
List index mysql cli
SQL
0 vote111 views1 answer
Sqlite closes value
SQL
0 vote69 views1 answer
Check if due date is less than todays date sql
SQL