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 vote135 views1 answer
Disableforiegn key check
SQL
0 vote170 views1 answer
How to make sure two tables have same exact data in sql
SQL
0 vote138 views1 answer
How to create notes in mysql
SQL
0 vote124 views1 answer
Alter table fulltext
SQL
2 votes138 views2 answers
Sql percentage
SQL
0 vote100 views1 answer
Connection error in mysql workbench
SQL
7 votes127 views6 answers
Group_concat mysql
SQL
3 votes134 views1 answer
Only join in sql
SQL
0 vote149 views2 answers
Select last 30 days sql
SQL
0 vote144 views2 answers
How to get last inserted id in sql server c#
SQL