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 vote168 views1 answer
Update table sql multiple set
SQL
0 vote177 views1 answer
MySQL import data from large CSV file
SQL
10 votes174 views6 answers
Between sql
SQL
1 vote182 views1 answer
Sqlalchemy order by descending
SQL
1 vote172 views1 answer
Sql Split string function
SQL
1 vote183 views1 answer
Sql dcl
SQL
1 vote187 views1 answer
Top 10 rows in mysql
SQL
1 vote196 views1 answer
Show databases mysql docker
SQL
0 vote169 views2 answers
Sql query for getting details by id
SQL
0 vote180 views1 answer
Query params sql insert python f string
SQL