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

1 vote292 views1 answer
Customer using hdfc bank sql query
SQL
0 vote280 views1 answer
Rabbitmq ui not working
SQL
0 vote285 views1 answer
Import sql in postgresql
SQL
8 votes290 views2 answers
Phpmyadmin default password
SQL
2 votes272 views1 answer
Plsql block
SQL
7 votes287 views1 answer
Sql server management studio turn on line numbers
SQL
2 votes283 views4 answers
Sql query interview questions
SQL
0 vote287 views2 answers
Suse stop MySQL
SQL
0 vote352 views1 answer
Sqlite send a query to a Sqlite DB with Ruby
SQL
0 vote294 views1 answer
Alter boolean column postgresql
SQL