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 vote175 views1 answer
Psql create usr
SQL
0 vote134 views1 answer
Create_engine sqlalchemy with parsed url sql server
SQL
8 votes161 views4 answers
Reset SQL auto increment
SQL
0 vote173 views1 answer
Offset in postgresql example
SQL
0 vote138 views1 answer
Get primary key of table
SQL
0 vote132 views1 answer
How to export table data from mysql table in sql format
SQL
1 vote141 views1 answer
Raise application error in oracle
SQL
0 vote138 views1 answer
Create table database in psql
SQL
2 votes135 views1 answer
Oracle virtual column
SQL
0 vote154 views2 answers
Php convert dbf to mysql
SQL