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 vote227 views3 answers
Java hide mysql login credentials
SQL
28 votes188 views6 answers
Mysql change user password
SQL
0 vote186 views1 answer
Redudancy in SQL
SQL
1 vote194 views1 answer
Mysql return if it contains
SQL
5 votes206 views2 answers
Get columns number sql
SQL
0 vote188 views1 answer
Oracle array
SQL
0 vote178 views1 answer
Power query case when
SQL
-1 vote133 views1 answer
How to create script to connect to oracle database and run query
SQL
0 vote213 views1 answer
Foreign key type uniqu mysql
SQL
0 vote178 views1 answer
Sql server manager close connection
SQL