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 vote109 views2 answers
Add colum in sql
SQL
1 vote111 views1 answer
Oracle user last connected
SQL
0 vote103 views1 answer
Dapper : operator does not exist: integer = integer[]'
SQL
6 votes111 views1 answer
Oracle pl sql source
SQL
11 votes106 views3 answers
How to get last row of table in sql
SQL
1 vote99 views1 answer
VERIFY INDEXES IN SQL ORACLE
SQL
6 votes118 views2 answers
Sql query to get the number of rows in a table
SQL
34 votes123 views6 answers
Install mysql client ubuntu
SQL
1 vote104 views1 answer
Autocommit mysql
SQL
0 vote108 views4 answers
Restart MySQL
SQL