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

12 votes203 views6 answers
How to install sqlite3 in python
SQL
11 votes145 views2 answers
Having clause
SQL
5 votes161 views1 answer
Sql check if date is between 2 dates
SQL
1 vote148 views1 answer
Database Queries
SQL
0 vote143 views1 answer
Alter table fulltext
SQL
13 votes162 views2 answers
Sql join
SQL
2 votes153 views1 answer
Delete all value query
SQL
0 vote176 views1 answer
How to define a non primary composite key in sql
SQL
0 vote158 views1 answer
Laravel eloquent get generated sql
SQL
0 vote145 views2 answers
How to set global time_zone in mysql
SQL