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 vote157 views1 answer
Database run
SQL
0 vote189 views1 answer
Oracle archivelog usage
SQL
2 votes177 views3 answers
Access denied for user 'root'@'localhost' mariadb
SQL
1 vote201 views1 answer
Tsql get beginning of year
SQL
0 vote145 views1 answer
Mitigation of sql injection
SQL
3 votes207 views2 answers
Brew restart mysql
SQL
6 votes203 views1 answer
Oracle rank
SQL
20 votes182 views1 answer
Sql change column types
SQL
0 vote198 views1 answer
Except in sql
SQL
0 vote150 views1 answer
Sqlalchemy filter relationship
SQL