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

0 vote191 views1 answer
Hotw to alter lengh character vayng postgres
SQL
0 vote174 views1 answer
Sql server 2012 create or alter procedure
SQL
12 votes177 views4 answers
How to take database dump in postgresql
SQL
3 votes179 views3 answers
Your password does not satisfy the current policy requirements
SQL
1 vote188 views1 answer
Display total number of tables in mysql
SQL
1 vote216 views1 answer
Mysql show long running queries
SQL
3 votes141 views1 answer
System.debug apex
SQL
17 votes188 views3 answers
How to change a collumn name in sql
SQL
0 vote182 views1 answer
Mysql to get column name in database
SQL
31 votes196 views3 answers
Sql count
SQL