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 vote127 views1 answer
Complete date is 1 year or not sql server
SQL
0 vote143 views1 answer
Mysql workbench primary key
SQL
0 vote140 views2 answers
Sql query in dax power bi
SQL
14 votes148 views1 answer
Excel is not a database
SQL
0 vote134 views2 answers
Select columns from 2 tables with foreign key
SQL
8 votes130 views1 answer
Unique vs primary key
SQL
0 vote133 views1 answer
Addition of 2 column value in mysql
SQL
0 vote149 views1 answer
Can you write relational algebra into sql queries
SQL
1 vote139 views1 answer
Date in where on datetime column clause mysql
SQL
0 vote180 views1 answer
Delete from table where length sql
SQL