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 vote153 views1 answer
Error code 1451 sql
SQL
0 vote138 views1 answer
Postgres populate table from another table
SQL
1 vote142 views1 answer
Sql server locks
SQL
0 vote157 views1 answer
How to define a save method in ruby for sqlite3 databases
SQL
7 votes137 views3 answers
Sql get last inserted row
SQL
5 votes141 views1 answer
Mysql count lines
SQL
2 votes138 views2 answers
How to get the date diff of 2 dates in the same fieldin sql server
SQL
2 votes142 views2 answers
Mamp connect mysql terminal
SQL
0 vote149 views1 answer
Sql '=' cannot be applied to date varchar(10) athena
SQL
0 vote148 views1 answer
Mysql update set sum
SQL