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 vote303 views1 answer
Mysql events not work
SQL
23 votes346 views6 answers
How to create table in sql
SQL
0 vote350 views2 answers
Mysql update two tables at once
SQL
0 vote337 views1 answer
Insert overwrite table in mysql in nifi
SQL
24 votes366 views4 answers
Postgres delete database
SQL
3 votes308 views1 answer
Oracle wait
SQL
-1 vote342 views1 answer
Auto increment psql not primary key
SQL
0 vote322 views5 answers
Linq cheat sheet
SQL
1 vote309 views1 answer
Index a database column sql
SQL
0 vote325 views1 answer
How to put 0 or 000 depending IDCustomer length in sql server
SQL