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 vote179 views1 answer
Mysql delete duplicate rows except one
SQL
0 vote164 views1 answer
How to put is null in where in clause
SQL
0 vote167 views1 answer
Top 3 salary in sql
SQL
0 vote152 views2 answers
Select limit ms sql
SQL
0 vote160 views1 answer
Mysql drop trigger
SQL
0 vote163 views1 answer
Mysql workbench procedure
SQL
3 votes152 views3 answers
Create a view postgres
SQL
0 vote169 views2 answers
Amazon linux postgresql client
SQL
0 vote163 views1 answer
Mysql order by rand limit 1 really slow
SQL
5 votes172 views1 answer
Oracle list days between two dates
SQL