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

4 votes190 views1 answer
Psql get sequences
SQL
0 vote210 views1 answer
Sql script to remove default from column
SQL
5 votes195 views1 answer
Oracle list days between two dates
SQL
0 vote188 views2 answers
Mysql create table if not exists
SQL
0 vote206 views1 answer
T-sql delete view if exists
SQL
0 vote207 views1 answer
Mysql aspas simples
SQL
4 votes198 views1 answer
Oracle delete last row
SQL
7 votes211 views2 answers
Where keyword sql
SQL
2 votes188 views2 answers
Oracle multiple insert
SQL
0 vote196 views1 answer
Hashpass
SQL