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 vote254 views1 answer
How to stop all connections to a psql 12 database?
SQL
2 votes249 views1 answer
Anonymous block plsql
SQL
2 votes280 views1 answer
Oracle block
SQL
16 votes276 views2 answers
Mysql date between two dates
SQL
0 vote253 views1 answer
Sql mod even odd
SQL
1 vote244 views2 answers
Sql convert datetime to year month
SQL
1 vote268 views1 answer
Oracle drop job if exists
SQL
1 vote258 views1 answer
PLS-00225 type
SQL
0 vote242 views1 answer
How to access to mysql without root
SQL
0 vote265 views2 answers
Import .sql into postgres db command
SQL