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

6 votes341 views2 answers
WHERE value IS sql
SQL
2 votes377 views5 answers
Install postgresql 10 centos 7
SQL
0 vote354 views1 answer
Get foreign table names mysql
SQL
15 votes351 views2 answers
Select Options
SQL
0 vote358 views1 answer
Alter table engine mysql
SQL
1 vote355 views1 answer
Sql how to duplicate a table
SQL
0 vote397 views2 answers
Unique key
SQL
8 votes386 views2 answers
Update sql server from another table
SQL
0 vote340 views1 answer
Dns slave zone convert
SQL
0 vote365 views1 answer
Query to generate query to drop primary keys or foreign key in ms sql server
SQL