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 vote205 views1 answer
Declare or use variable in snowflake
SQL
0 vote205 views1 answer
Mysql workbench indent formatting
SQL
12 votes347 views2 answers
Find duplicates mysql column
SQL
0 vote205 views1 answer
Oracle merge insert if not exists
SQL
1 vote201 views1 answer
Access the postgres psql
SQL
17 votes199 views3 answers
Cast in sql server
SQL
1 vote198 views3 answers
Execute sp in sql server
SQL
2 votes191 views1 answer
Drop table purge
SQL
1 vote200 views1 answer
Group_concat order by
SQL
2 votes219 views1 answer
Merge firstname and lastname in sql oracle
SQL