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 vote146 views1 answer
Make a socket server to detect changes in mysql
SQL
1 vote150 views1 answer
Access denied for user 'root'@'localhost' python sql-connect error
SQL
0 vote152 views1 answer
Get last three characters in mysql column
SQL
1 vote156 views1 answer
Postgres start database on linux
SQL
1 vote146 views1 answer
Cross schema query oracle 2 users
SQL
-1 vote151 views5 answers
Not in sql
SQL
0 vote158 views1 answer
A good way of running a SQL query in JDBC using a parameterized statement
SQL
9 votes158 views5 answers
Sql delete duplicate rows but keep one
SQL
0 vote154 views1 answer
Oracle session statistics
SQL
1 vote184 views2 answers
Changes not showing on website server odoo
SQL