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

2 votes189 views1 answer
Username sql
SQL
3 votes160 views2 answers
Search text in all sql server stored procedure
SQL
0 vote156 views1 answer
How to create a new db from dumb file mysql
SQL
1 vote145 views1 answer
Sql string function update replace
SQL
0 vote167 views1 answer
Table user postgres
SQL
0 vote146 views1 answer
Apt install sql server
SQL
5 votes143 views2 answers
Mysql drop table cascade
SQL
0 vote144 views1 answer
Suse status MySQL
SQL
2 votes157 views1 answer
Sql percentage with % rounded down
SQL
0 vote154 views1 answer
Shell script to log mysql cpu usage
SQL