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 vote95 views1 answer
Search In the Database using Text
SQL
0 vote142 views1 answer
Copy from one table to another postgres using matching column
SQL
0 vote109 views1 answer
Drop all procedures sql server
SQL
1 vote108 views1 answer
Host 127.0 0.1 is not allowed to connect to this mysql server
SQL
0 vote105 views1 answer
Sql '=' cannot be applied to date varchar(10) athena
SQL
0 vote109 views1 answer
Apt install sql server
SQL
1 vote113 views2 answers
Procedure syntax
SQL
0 vote107 views1 answer
Left join in codeigniter query builder
SQL
0 vote95 views1 answer
Ms Sql set us timezone
SQL
1 vote90 views2 answers
Mysql type conversion
SQL