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

5 votes302 views1 answer
Oracle drop index if exists
SQL
1 vote265 views1 answer
Mysql select update same table
SQL
2 votes271 views2 answers
Mamp connect mysql terminal
SQL
0 vote281 views1 answer
Get a list of tables and the primary key
SQL
0 vote276 views1 answer
Sql find all different values in column
SQL
0 vote274 views1 answer
How to close external sql connection in laravel
SQL
17 votes283 views6 answers
MySQL ORDER BY
SQL
0 vote280 views2 answers
Mysql decimal remove trailing zeros
SQL
0 vote268 views1 answer
Mysql return column names when table is empty
SQL
0 vote276 views1 answer
Mysql show category once count how many products
SQL