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 vote118 views1 answer
How to drop columns with constraint from a table in sql script
SQL
1 vote126 views1 answer
Postgres power
SQL
1 vote139 views1 answer
Sqlstate[imssp]: the active result for the query contains no fields.
SQL
3 votes124 views2 answers
Enter mysql command line
SQL
3 votes118 views1 answer
Create a table with an id in mysql
SQL
0 vote105 views1 answer
Count column of tables psql
SQL
2 votes81 views1 answer
Oracle sql drop column if exists
SQL
-1 vote119 views1 answer
Add bool column in sql
SQL
0 vote120 views1 answer
Kill slow queries mysql
SQL
0 vote130 views1 answer
How to know if table in rigt or left in sql
SQL