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 vote244 views1 answer
Mysql grant user privileges to database that has suffix and prefix
SQL
0 vote248 views1 answer
Convert rows to columns in sql server
SQL
0 vote232 views1 answer
Mysql add to value
SQL
1 vote238 views2 answers
Insert sqlite
SQL
4 votes228 views2 answers
Mysql how to change default charset
SQL
2 votes252 views4 answers
Check timezone of mysql database
SQL
1 vote248 views1 answer
Cross schema query oracle 2 users
SQL
0 vote219 views1 answer
What is the essence of SQL?
SQL
0 vote243 views1 answer
Empty table sqlite
SQL
3 votes261 views1 answer
Create a table with an id in mysql
SQL