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

16 votes367 views3 answers
MySQL 8.0 - Client does not support authentication protocol requested by server; consider upgrading MySQL client
SQL
1 vote346 views1 answer
Altering the column name in MySQL to have a default value
SQL
0 vote354 views1 answer
Mysql multiple primary keys
SQL
0 vote357 views1 answer
How to make full text search dynamic in mysql
SQL
47 votes407 views6 answers
Add column mysql
SQL
0 vote340 views2 answers
Csv into data postgres
SQL
0 vote351 views2 answers
Cambiar nombre tabla mysql
SQL
49 votes438 views6 answers
Install mysql ubuntu
SQL
16 votes385 views6 answers
Mysql find duplicates in same table
SQL
1 vote326 views1 answer
How to see all table partition in oracle
SQL