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 vote282 views1 answer
Mysql workbench search all tables
SQL
1 vote270 views1 answer
Metada in sql
SQL
0 vote346 views1 answer
Add user mysql wordpress
SQL
0 vote301 views1 answer
Alter table fulltext
SQL
2 votes306 views1 answer
Sql ends with string
SQL
1 vote316 views1 answer
Postgresql round double precision
SQL
0 vote295 views1 answer
On update current_timestamp jpa
SQL
2 votes298 views1 answer
Sql server find table name
SQL
1 vote318 views1 answer
Size of all tables in a schema oracle
SQL
3 votes304 views2 answers
Plsql print
SQL