Pl sql case

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

Pl sql case

CASE [ expression ]

   WHEN condition_1 THEN result_1
   WHEN condition_2 THEN result_2
   ...
   WHEN condition_n THEN result_n

   ELSE result

END

Source: techonthenet.com

Similar codes

-1 vote126 views1 answer
How to check table exists or not in postgresql
SQL
3 votes153 views5 answers
Foreign keys
SQL
5 votes86 views1 answer
Mongodb vs
SQL
0 vote123 views1 answer
Sql server select furst day of current year
SQL
0 vote130 views1 answer
Set open file limit mac catalina mysql
SQL
15 votes155 views4 answers
Mysql export database command line
SQL
0 vote132 views1 answer
Sql tablo hangi sp de
SQL
0 vote241 views1 answer
Multiple replace value mssql
SQL
0 vote135 views1 answer
Mysql changer nom table
SQL
1 vote133 views1 answer
Multiple count in sql
SQL